We want to export all users from User Management with all details such as AD groups and local group access details.
Please suggest/advice.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.