Searching for Discouraged Members


Well-known member
I know I have placed a few members in the discouraged (group). But for the life of me I cannot find the ones I've placed in there. With "Misirable Users", it was a group, so you could easily display those members that were in that group. How can I do this with XF? I see how to do it with discouraged IP's but not discouraged members. Was this an oversight in the software?

Shouldn't "discouraged" be a selectable criteria in the "Search for members" page?

Jake Bunce

XenForo moderator
Staff member
Shouldn't "discouraged" be a selectable criteria in the "Search for members" page?
Probably should be.

You can run this query on your database to generate a list of discouraged users:

SELECT u.user_id, u.username
FROM xf_user_option AS uo
LEFT JOIN xf_user AS u ON (u.user_id = uo.user_id)
WHERE uo.is_discouraged = 1;
The discouraged flag is xf_user_option.is_discouraged in the database.


A "user" is a user in xenforo.
A user status can be banned, discouraged, active, inactive, or part of a usergroup.

"discouraged" isn't a usergroup.

But I agree, you can browse discouraged IP addresses, but not users. It would be nice if 1.1 would facilitate that.


Well-known member
I just discovered there's no way to list / find all discouraged users. Would love to see this added!