See this tutorial for the easiest way to export JIRA users to Excel: http://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.)
I found 2 ways:
Hi Mirco and thanks,
Glad you like it. We really needed this for our own Jira as well.
If you have any feature request feel free to use my Service Desk: https://langhornweb.atlassian.net/servicedesk/customer/user/login?destination=portals
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.
Ok so you are using Jira Cloud.
It sounds like a bug to me. According to https://confluence.atlassian.com/cloud/export-users-from-a-site-833925313.html user names are not encrypted.
I would contact Atlassian about this issue.
Wooo GDPR ;) But seriously, this is because usernames have become restricted in Atlassian Cloud. As profile visibility controls are not fully rolled out yet, you can't force visibility (nor am I sure you will be able to force username visibility even once they're out). For all intents and purposes, email is the best key you can use now. Depending on what you're trying to get the user list for, I can offer some alternative methods.
That makes sense, thanks Boris! We're migrating cloud projects to our server instance and our username format is not consistent across them. We used the cloud user list export with a script to clean the usernames before importing into server to avoid duplicate users. Any ideas for alternative methods to get a username CSV file would be much appreciated!
For Jira Data Center, I had success in using the REST API
To try it out, Insomnia is a free tool that can build queries in a very easy way.
I've embedded that in a custom .NET tool used for migration from Cloud to Data Center.
As per an older comment, I indeed used e-mail addresses to map users between Cloud and our AD users.
Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...
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