How do I extract all the users in Excel or CSV format in JIRA for which user licenses are being used

[Dhaval Patel]

How do I extract all the users in Excel or CSV format in JIRA for which user licenses are being used?

[somethingblue · Accepted solution]

Hi Dhaval,

You can get the list from SQL statements using the article How to Get a List of Active Users Counting Towards the JIRA application license. The previous article used in conjunction with How to Export Users to CSV should help! 

Note: You may need to modify the commands for your db.

In addition, the Active User Filter add-on can also perform this task.

Cheers,

Branden

[Lasse Langhorn]

You can use the Jira User Export app for Jira Server. It is free to download and use: https://marketplace.atlassian.com/apps/1220535/jira-user-export?hosting=server&tab=overview

regards

Lasse Langhorn

[Jonathan Salisbury]

You can't get a free trial license because the Atlassian page trumpets it's usual mantra about everyone going cloud now.