You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Can anyone help with a query where I can find users who recently got inactive , We have AD for users in Jira server, Please let me know if we can possible get query who was inactive since 15 or 30 days before.
No there isn't unfortunately. JQL is about issues, not users. Do you have database access? You can run a query. Else there is a plugin for this.
This not supported natively and difficult to access as the lastlogindate is held as user properties.
you can get this from the db using
SELECT cu.id, cu.directory_id, user_name, lower_user_name, attribute_name, attribute_value,active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, credential, deleted_externally, external_id
FROM public.cwd_user cu
left outer join cwd_user_attributes cua on cu.id = cua.user_id and attribute_name = 'login.lastLoginMillis'
if you have scriptrunner you can use variations if this script