User account listing for JIRA Server

[Bob Vasey]

Looking for information on exporting user account information like, name, email address and last used date. Or the ability to run a script to produce locally.

Thank you in advance for any useful information.

[Kurt Klinner]

@Bob Vasey 

Hi Bob,

one option would be to query the database directly.

Below an example that should work on mysql

Hope that helps

Cheers

Kurt

SELECT u.user_name, u.first_name, u.last_name, u.email_address
from_unixtime((cast(attribute_value AS UNSIGNED)/1000)) AS "Last Login"
FROM cwd_user u
JOIN (
SELECT DISTINCT child_name
FROM cwd_membership m
JOIN licenserolesgroup gp ON m.parent_name = gp.GROUP_ID
) AS m ON m.child_name = u.user_name
JOIN (
SELECT *
FROM cwd_user_attributes
WHERE attribute_name = 'login.lastLoginMillis'
) AS a ON a.user_id = u.id
JOIN cwd_directory d ON u.directory_id = d.id
ORDER BY "Last Login" DESC;