How to identify the source of Confluence groups when using multiple directories

Still need help?

The Atlassian Community is here for you.

Ask the community

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.


Last modified on Oct 14, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.