Editing (v7+)

Users not in groups

Permalink January 06, 2014 at 3:26 PM

I have some users that aren't in a group. How can I search to find those users so I can add them to one?

bbeng89 replied on Jan 6, 2014 at 4:16 pm Permalink Reply

Hello,
I'm not sure if there is a way to do this through the dashboard but you should be able to find the users with a MySQL query. I'm not sure if this is the most efficient query, but it should work:

SELECT uID, uName, uEmail FROM Users u LEFT JOIN UserGroups ug ON u.uID = ug.uID WHERE gID IS NULL;