The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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 @Ravi Gupta ,
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 @Ravi Gupta ,
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.
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.