How to identify the source of Confluence groups when using multiple directories
Platform Notice: Server and Data Center Only. This article only applies to Atlassian products on the server and data center platforms.
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.