Export Jira User List

[Saadiq Patel]

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

[Bob Swift · Accepted solution]

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.

[Saadiq Patel]

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.

[Jutamat _Kate_ Phothisitthisak]

we use JIRA CLI as well to getUserlist, AddUserlist also DeactivateUserList, Nice Tool

[Midori]

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

[Boris Berenberg - Atlas Authority]

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.

[ITSupport]

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]

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}

[Rodolfo So]

Hi,

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

[Lars Mählmann]

@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

[Nar Kumar C. - Narva Software]

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.

[Shwetha_Peruri]

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

[Nar Kumar C. - Narva Software]

Unfortunately you need to be admin to export users.

[Suresh Srini]

How do I use this for my company?

https://admin.atlassian.com

[MJ]

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

[Manohar Venkataraman]

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

[Kevin Mahoney]

I would have to agree.

[Jay Kantaria]

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

[Christian Dang]

Still can't :(

[Suresh Srini]

I used SQL Query if you have database access. YOu need only read access.

Select Jira.dbo.cwd_membership.parent_name, Jira.dbo.cwd_membership.parent_name, cwd_membership.lower_child_name, Jira.dbo.cwd_user.display_name, Jira.dbo.cwd_user.email_address

from Jira.dbo.cwd_membership

INNER JOIN Jira.dbo.cwd_user ON Jira.dbo.cwd_membership.lower_child_name = Jira.dbo.cwd_user.lower_user_name

Select Jira.dbo.cwd_membership.parent_name, Jira.dbo.cwd_membership.parent_name, cwd_membership.lower_child_name, Jira.dbo.cwd_user.display_name, Jira.dbo.cwd_user.email_address

from Jira.dbo.cwd_membership

INNER JOIN Jira.dbo.cwd_user ON Jira.dbo.cwd_membership.lower_child_name = Jira.dbo.cwd_user.lower_user_name

you can try one of them. I was able to get group name and its members as well.

[Kevin Mahoney]

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.