nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Identify inactive users

Serge5

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!

Accepted answers

teilor_soares

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

All comments

teilor_soares

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

Serge5

Hi @TAS,

Many thanks! Have a nice day!

Serge5

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 &gt;= '1388541600000' OR a.attribute_value IS NULL ORDER BY a.attribute_value;

Cheers,

Serge

Tom Keidar_0quwmw

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration

user

database

user-management

mysql