The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.