Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Identify inactive users

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!

4 answers

1 accepted

3 votes
Answer accepted

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

 

Hi @TAS,

Many thanks! Have a nice day!

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

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you