Is it possible to export all users from User Management

RG_0m27n8

We want to export all users from User Management with all details such as AD groups and local group access details.

 

Please suggest/advice.

Rilwan Ahmed

Hi @RG ,

There is no direct way to export all user details from UI. What you can do is go to admin settings --> User management 
Copy all users listed (CTRL+A) and paste it to excel. 

OR 
You can run related DB query

#In PostgreSQL db
select cwd_user.user_name, cwd_user.display_name, cwd_user.email_address,array_to_string(array_agg(cwd_membership.parent_name), ',') as "MemberOf" from cwd_user inner join cwd_membership on cwd_membership.child_id = cwd_user.ID where cwd_membership.membership_type='GROUP_USER' group by cwd_user.user_name, cwd_user.display_name, cwd_user.email_address; 

#In hsqldb
select cwd_user.user_name, cwd_user.display_name, cwd_user.email_address, GROUP_CONCAT(cwd_membership.parent_name SEPARATOR ', ') as "MemberOf" from cwd_user inner join cwd_membership on cwd_membership.child_id = cwd_user.ID where cwd_membership.membership_type='GROUP_USER' group by cwd_user.user_name, cwd_user.display_name, cwd_user.email_address;

 

Even python script can be used as described as https://confluence.atlassian.com/jirakb/how-to-get-jira-user-information-with-roles-and-groups-in-an-automated-way-1108488336.html