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

6 answers

1 accepted

This widget could not be displayed.

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.

This widget could not be displayed.

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

 

 

This widget could not be displayed.

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

This widget could not be displayed.

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.

This widget could not be displayed.

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

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}

This widget could not be displayed.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

113 views 2 0
Join discussion

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