How do I find users that are not a member of any groups?

[Richard Saffell]

Somehow new users were registered but not added to the confluence-users group, so when they login to our Confluence they get an Access Denied error.  So I need to find all users in Confluence that are not a member of a group so I can add them to the confluence-users group.

[salehparsa]

Hi Richard,

You may find them with following SQL query:

select u.user_name, g.group_name from cwd_user u
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
where (g.group_name != 'confluence-administrators' and g.group_name !='confluence-users')

Above query show users and groups names. However, it filters those users belong to confluence-administrators or confluence-users 

Hope it helps.

Saleh