Identify inactive users

[Sergio]

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!

[teilor_soares · Accepted solution]

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

[Tom Keidar]

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.

[Sergio]

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

[Sergio]

Hi @TAS,

Many thanks! Have a nice day!