Summary

Confluence can use multiple user directories as the source of its users and groups. If for any reason, an infrastructure change is needed in those directories, you may wish to know which groups would be impacted in Confluence.

The main purpose of this document is to help you identify the origin of each group in Confluence through the database.

Environment

• Confluence Server or Data Center
• Multiple external directories (e.g. Jira, Crowd, LDAP, AD)

Solution

Run the following query at Confluence database:

SELECT g.group_name, d.directory_name
FROM CWD_GROUP g
JOIN CWD_DIRECTORY d
ON g.directory_id = d.id;

It will display all groups along with its source directory.