Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Export Jira User List

What is the best method to export all JIRA users in the system? I want to produce a CSV (or similar).

Note this is the on demand version

8 answers

1 accepted

JIRA Command Line Interface getUserList will produced a csv file. For JIRA (as opposed to Confluence), it requires a group. You can usually use users for OnDemand unless you have made changes from the default behaviour.

Thanks Bob, i was hoping to be able to export from within the system as we have couple of Administrators that time to time would like to audit logins and make inactive users that have left.

Like Jens Friedrich likes this

There is always Jira REST API (https://docs.atlassian.com/jira/REST/latest/) and export data in a manner that fits you best.

Lars Mählmann Community Leader Oct 13, 2017

here is an example how I did it:

{code}

http --auth username https://jira.url.org/rest/api/2/group/member\?groupname\=jira-users\&maxResults\=140 | jq '.values | .[]| .key' | tr -d '"' >> active_jira_user.txt

{code}

Like Malik Mangier likes this

Hi,

I would like to ask how you run this command? Thanks

Lars Mählmann Community Leader Sep 27, 2018

@Rodolfo - I do it on the terminal (bash/zsh on Linux or Unix(MacOS)) but I guess it runs on Windows CMD as well.

Tools:

* Jira Rest API

* httpie - a human curl

* jq - a parser for json on commandline

* tr - a bash command to remove '"'

I believe it works with postman as well.

I hope it helps

Cheers Lars

Like Malik Mangier likes this

With the Better Excel Plugin you can export all user information to a customizable Excel spreadsheet, post-process in Excel (if necessary) and then convert to CSV if that fits your use case better than an XLSX file.

The default Excel file will contain the following data for each user account:

  • User name (login name)
  • Full name (display name)
  • Email address
  • Status (Active / Inactive)
  • Directory in which the user account is managed
  • Groups in which the user is a member
  • Login count
  • Last login time and the number of days since then
  • Last failed login time
  • Current and total failed login count
  • Project roles: the list of project keys plus the user's roles in those, in a single searcheable, filterable cell. Ex: DROIDAPP: Developers, Users; IOSAPP: Developers, Users; WEB: Users;

See: http://www.midori-global.com/products/jira-better-excel-plugin/documentation/user-export

excel-user-export.png

 

 

2 votes
MJ Atlassian Team Jul 11, 2013

You can not create user backups on the OnDemand platform yourself. Depending on your needs, this might be something we can assist you with if you create a support case at support.atlassian.com

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

I would have to agree.

Like Jens Friedrich likes this

It is 2020 and we still can't do simple export of users like we can export the issues :)

Like Jens Friedrich likes this

I am not sure about Jira Server but if you are using Jira Cloud (on-demand), then this feature is already implemented (no need to install third party add-on).

Admin users can export all Jira users to CSV file.

Here is how I use it:

  1. Go to https://admin.atlassian.com
  2. Click on manage users button which will take you to user management page
  3. There is export feature with button Export users

See the screenshot I took from our Jira Cloud instance below.

user-export.png

Hi is there any way to do this if you are not an admin?

Unfortunately you need to be admin to export users.

How do I use this for my company?

https://admin.atlassian.com

If you have access to your DB tool, ours in Sequel, you can query the table that the users are stored on and export that. Not the most user friendly, but that's the only way I know of at the moment.

For example, our JIRA db instance is named 'jiradb2' and the full table name in this environment is 'jiraschema.cwd_user'.

SQL would be:

use jiradb2;

select * from jiraschema.cwd_user;

You can narrow you results by specifying the column(s) instead of getting them all.

Suggest an answer

Log in or Sign up to answer
TAGS

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