Is it possible to export all users from User Management

[RG]

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 · Accepted solution]

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

[Fabio Racobaldo _Herzum_]

Hi @RG ,

you can do that through a DB query otherwise you need to use one of the third part app like this https://marketplace.atlassian.com/apps/1220535/jira-user-export?tab=overview&hosting=datacenter

Hope this helps.

Fabio