How to determine the user directory of a specific group synced within the Jira database
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
This article will provide a query that can help to identify from which Jira User Directory a specific user group is synced.
Environment
Jira 8 and higher
Solution
The query below will return the group name and the directory name that the group is synced from:
1
2
3
4
select cg.group_name, cd.directory_name
from cwd_group cg
inner join cwd_directory cd on cg.directory_id = cd.id
where cg.lower_group_name = '<group name in lower case>';⚠️ Replace the <group name in lower case> in the query above with the all lower case name of the group. For example, if the group name is 'Administrators' you would need to use 'administrators'.
Was this helpful?