How to identify the source of Confluence groups when using multiple directories
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.
環境
- Confluence Server または Data Center
- Multiple external directories (e.g. Jira, Crowd, LDAP, AD)
ソリューション
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.