How to identify the source of Confluence groups when using multiple directories
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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:
1
2
3
4
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.
Was this helpful?