Purpose

You want to look up users in the database that do not belong to a certain group, but this cannot be done through the UI. For example, if you want to disable any users that do not belong to confluence-users and should not have access you can run the query below. To run this, just replace the <group_name> with the name of the group you want to exclude.

Solution

1. Connect to your database and run the following query:

SELECT *
FROM cwd_user
WHERE id NOT IN (SELECT m.child_user_id FROM cwd_membership AS m
JOIN cwd_group AS g ON m.parent_id = g.id
WHERE g.group_name = '<group_name>' AND m.child_user_id IS NOT NULL);