You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Is there a way to export the users to Excel?
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.
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.