Is there a way to export the users to Excel?
Yes.
Better Excel app enables this, see the Exporting Jira users to Excel tutorial.
.
Audra,
There's no way, at least to my knowledge, i use a db query for this:
<br>u.user_name, <br>u.last_name, <br>u.first_name, <br>u.email_address, <br>m.parent_name, <br>substring( ua_lastlogin.attribute_value, 0, len(ua_lastlogin.attribute_value) - 2 ), <br>u.active<br>FROM [JIRA7].[jiraschema].[cwd_user] u<br>LEFT JOIN [JIRA7].[jiraschema].[cwd_user_attributes] ua_lastlogin<span> </span>on u.id = ua_lastlogin.user_id<span> </span>and ua_lastlogin.attribute_name =<span> </span>'lastAuthenticated'<br>LEFT JOIN [JIRA7].[jiraschema].[cwd_membership] m<span> </span>on u.id = m.child_id<br>ORDER BY u.user_name<span> </span>asc, u.last_name<span> </span>asc, u.first_name<span> </span>asc, m.parent_name<span> </span>ascSELECT
<br>
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<br>
FROM
[JIRA7].[jiraschema].[cwd_user] u<br>
LEFT
JOIN
[JIRA7].[jiraschema].[cwd_user_attributes] ua_lastlogin<span> </span>
on
u.id = ua_lastlogin.user_id<span> </span>
and
ua_lastlogin.attribute_name =<span> </span>
'lastAuthenticated'<br>
[JIRA7].[jiraschema].[cwd_membership] m<span> </span>
u.id = m.child_id<br>
ORDER
BY
u.user_name<span> </span>
asc
, u.last_name<span> </span>
, u.first_name<span> </span>
, m.parent_name<span> </span>
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
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
Thank you Aron, this worked like a charm!
Thank you Mirek, I will look into this option too.
Great work!
Please accept my answer so that other users can see that, too.
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;
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
is there any way to use this with PostgreSQL?
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 CastilloAtlassian Support
how can i find my JIRA server schema name ?
It looks like you're new here. Sign in or register to get started.
