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:

• Managing Multiple Directories

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_id to match the directory you are checking. For a listing of directory IDs, you will want to check the cwd_directory table.