User List Export

Is there a way to export my user list? I have a bunch of users and want to clean it up a bit.

6 answers

It's bizarre that you can't export a user list from the Administration interface. I have added a request for this, please vote for it: https://jira.atlassian.com/browse/JRA-23783

It's completely bizzarre to me as well. Not everyone is proficient with the CLI or SQL - neither should be required for basic administrative functionality.

See this tutorial for the easiest way to export JIRA users to Excelhttp://www.midori-global.com/products/jira-better-excel-plugin/documentation/user-export

(Excel allows you to filter, search, post-process your user account data easily.)

excel-user-export.png

0 votes
Boris Berenberg Community Champion Apr 23, 2016

The Active User Filter add-on (https://marketplace.atlassian.com/plugins/cr.tin.ActiveUserFilter.active-user-filter/server/overview) allows you to export users to CSV.

Unfortunately the CSVs exported from this Addon is are broken because they contain unwanted line breaks. And it only exports the currently visible users from the user management page, e.g. the first 100, and not all users.

Boris Berenberg Community Champion Jul 18, 2016

Can you let me know what version of JIRA you are using? I would like to see if I can reproduce the unwanted line breaks.

The export limitation is based on the search results. If you limit the search to show 100 per page, then that is all the add-on will work with. All you need to do is set it to 10,000+ and it will export everyone. 

Hi! We're using JIRA 7.1.6 and unfortunately I cannot select to see more than 100 users per page:

2016-07-19 12_18_52-Users - JIRA.png

 

Boris Berenberg Community Champion Aug 05, 2016

You can set it to "All" and it will show you everything.

If you get your list of users and copy the text from the page along with the headers into google docs.  Not high tech but it worked for me.

what if you have 2233665544 users?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,088 views 0 8
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you