Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,589
Community Members
 
Community Events
165
Community Groups

Is it possible to export all users from User Management

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

 

Please suggest/advice.

2 answers

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

0 votes

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 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...

14,763 views 37 47
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you