Hi All,
Could someone share with me SQL request which help to identify inactive users in jira (from the database), say the users who have not logged in the past 6 (or 12) months.
JIRA v6.2
MySQL v5.0.95
Unfortunately I'm not very familiar with SQL requests so I hope on your help.
Many thanks in advance!
Hi Serge, in the link below you can found a very complete query in the Matheus answer to retrieve this information https://answers.atlassian.com/questions/313771
-Teilor
Here is a Jira cloud addon developed by my company that allows you to search, filter and bulk delete users:
https://marketplace.atlassian.com/apps/1221764/user-management-by-toros
In addition, it allows you to search for inactive users (users who haven't login in a while) and perform some bulk operation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, I have little modify SQL request for MySQL, hope it will be helpful for someone other.
SELECT u.user_name as "Username", u.display_name as "Full Name", from_unixtime(round(a.attribute_value)/1000) as "Last Login" FROM cwd_user u LEFT JOIN cwd_user_attributes a ON u.id = a.user_id AND attribute_name = 'login.lastLoginMillis' WHERE a.attribute_value >= '1388541600000' OR a.attribute_value IS NULL ORDER BY a.attribute_value;
Cheers,
Serge
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.