List of Group Memberships per Directory
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
Symptoms
When making plans to migrate users from one directory to another, it's helpful to have a list of all existing memberships. It is necessary to re-add the group memberships once the new directory is being used, see here for more details:
Resolution
There is no easy way to get a listing of all member via JIRA's interface. With that, using the database may provide better results:
Here is an example of getting all group memberships in JIRA's internal directory, ordered by Groups and then the members in that group.
1
select parent_id,parent_name,child_id,child_name from cwd_membership where directory_id = 1 order by parent_name,child_name;ℹ️ This query was written via PostgreSQL and may need to be modified depending on your database.
You will want to modify the
directory_idto match the directory you are checking. For a listing of directory IDs, you will want to check thecwd_directorytable.
Was this helpful?