User List Export

Deleted user December 3, 2013

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

10 answers

10 votes
Manohar Venkataraman December 16, 2013

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

6 votes
Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 11, 2019
mfabris
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2019

You sir are a hero of the community for finally making a free app to do this. 

You have all my esteem and gratitude, and those of thousands of Jira Admins out there.

Like # people like this
Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2019

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

Regards

Lasse

Sky Moore October 31, 2019

Much gratitude to you for this.  Saved me having to write a solution myself.  Thank you so much!

Nestor Oubina April 3, 2020

Great job, Lasse.

I will let you know if I find any trouble or possible improvement.

 

Thank you very much.

6 votes
Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 11, 2014

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.

2 votes
Rudy Dullier July 20, 2019

Hi all,

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.

https://YOUR-SERVER/rest/api/latest/user/search?username=.&startAt=1&maxResults=2000&includeActive=true&includeInactive=true

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.

Cheers

2 votes
Midori
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 24, 2016

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

1 vote
DevOps @ Freshheads May 13, 2020

I made a simple python script to get a total user list.

Please be aware that this is used on jira (8.8.1) server:

Also, formatting doesn't work as it should here, please use the proper python indentation

import os
from jira import JIRA

#notes:
# python script for jira server 8.8.1
# python lib used:
#     - https://pypi.org/project/jira/
#     - https://jira.readthedocs.io/en/master/index.html
# other documentation: https://docs.atlassian.com/software/jira/docs/api/REST/8.8.1/

# author: rutger<dot>verhoeven<at>gmail<dot>com

# reminders:
# export ldappassword="<password>" on the cli / terminal

#todo:
#https://developer.atlassian.com/server/jira/platform/oauth

creduser =
'yourusername'
password = os.environ.get('ldappassword')

jira = JIRA(

    options = {'server': 'https://jira.your.url'},
   
basic_auth=(creduser, password)
    )

users = jira.search_users(
'.', includeActive=True,includeInactive=False,maxResults=250)

# wildcard for all users is '.'


for i in users:
    print(i.displayName)
    print(i.key)
    print(i.emailAddress)
    print("")
Sky Moore May 13, 2020

DevOps @ FreshheadsI'll give this a try soon.  Thank you for submitting.  I imagine many will benefit from this work.

1 vote
Teck-En
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 4, 2013
0 votes
Heather Rimmey June 19, 2019

I just did a CSV export and the file is encrypting the usernames. How can i get an export with unencrypted usernames?

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2019

Hi Heather,

Are you using the Jira User Export app for this CSV export?

Regards

Lasse

Heather Rimmey June 20, 2019

Hi Lasse,

Thanks for your response! I'm using the native cloud "Export Users" feature on the User Management administration screen. 

Screenshot 2019-06-20 09.36.06.png

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2019

Hi Heather,

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.

Regards

Lasse

Boris Berenberg - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2019

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.

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2019

Boris, You are right. OMG.

Regards

Lasse

Heather Rimmey June 20, 2019

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!

Boris Berenberg - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2019

I would definitely use emails to map the users given that you have an authoritative list for internal users. If you are dealing with external staff in the Cloud instance then it gets move complicated. 

0 votes
Kenneth Kron July 7, 2018

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.

Mohamed Alaoui July 31, 2018

what if you have 2233665544 users?

Deleted user February 20, 2019

This kinda worked for me as a quick "export" to Excel...

Capture.PNG

Deleted user February 20, 2019

The power of copy paste
:D :D :D

Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 6, 2019

Martin - you can't copy & paste all of it at once, so you're stuck with paging through all of it, and even when you do, you wind up with a pile of specially formatted $#!% (merged cells, etc) to deal with, making sorts in excel impossible without further manual editing.

Like Павел likes this
0 votes
Boris Berenberg - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 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.

deepblue networks AG July 17, 2016

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 - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 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. 

deepblue networks AG July 19, 2016

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 - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 5, 2016

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events