You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great work!
Please accept my answer so that other users can see that, too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.