User list export

[Audra Bonacki]

Is there a way to export the users to Excel?

[Aron Gombas _Midori_ · Accepted solution]

Yes.

Better Excel app enables this, see the Exporting Jira users to Excel tutorial.

.

[Audra Bonacki]

Thank you Aron, this worked like a charm!

[Aron Gombas _Midori_]

Great work!

Please accept my answer so that other users can see that, too.

[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

[Eric Haskett]

I used this on our MySQL server to get a CSV export:

mysql> select id, user_name, lower_first_name, lower_last_name, active into outfile '/tmp/jirausers.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' from cwd_user;

[Mirek]

Admin Tools for JIRA also give that ability (also some additional features) that you can use to administer JIRA - https://marketplace.atlassian.com/plugins/pl.com.tt.admintoolsforjira.AdminToolsForJira/server/overview

[Audra Bonacki]

Thank you Mirek, I will look into this option too.

[Gaston Valente]

Audra,

There's no way, at least to my knowledge, i use a db query for this:

SELECT    
u.user_name,    
u.last_name,    
u.first_name,    
u.email_address,    
m.parent_name,    
substring( ua_lastlogin.attribute_value, 0, len(ua_lastlogin.attribute_value) - 2 ),    
u.active
FROM [JIRA7].[jiraschema].[cwd_user] u
LEFT JOIN [JIRA7].[jiraschema].[cwd_user_attributes] ua_lastlogin on u.id = ua_lastlogin.user_id and ua_lastlogin.attribute_name = 'lastAuthenticated'
LEFT JOIN [JIRA7].[jiraschema].[cwd_membership] m on u.id = m.child_id
ORDER BY u.user_name asc, u.last_name asc, u.first_name asc, m.parent_name asc

 you need to replace JIRA7 with your db name and jirachema with your schema name,

if you're not using sql server yo can delete both

[Om Joshi]

is there any way to use this with PostgreSQL?

[Adrian Castillo]

Hi @Om Joshi

You can use the above query that @Gaston Valente shared (thank you!) but you'll need to replace the length function that he's using, in addition to the database name and schema name of course.

Before:

len(ua_lastlogin.attribute_value) - 2 )

After:

length(ua_lastlogin.attribute_value) - 2 )

Details can be found on this function in the official PostgreSQL documentation.

Please let me know if you have any questions!

Regards,

Adrian Castillo
Atlassian Support