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.
Unfortunately I'm not very familiar with SQL requests so I hope on your help.
Many thanks in advance!
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;
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs