List of Group Memberships per Directory
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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.
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.