XF 1.5 How to find all users with "Display user as staff" selected?

[andrewkm]

Just as the title says.
How would I go about finding all users on my board who had "Display user as staff" selected?

I have quite a mess on my forum with some old members having this due to a bad staff setup from the past, how would I go about finding all the users who have this option selected in their profile so I can remove it.

 

[andrewkm]

Figured it out.

For those who find this thread:

Had to search with these settings:

 

[whynot]

Isn't enough to place a tick only to "Staff Member"?

 

[xenfans]

Double check your findings though, go to the phpmyadmin or from cli into the mysql database, and sort the table that has the fields that disclose who's staff. I imported a few sites from xf and ipb, and people that didn't show in xenforo as such were clearly listed in the db.