JQL for inactive users since one month

Question

Hi,

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.

Regards,

Suma

Bert van Dijk _TMC_nl_ · Accepted Answer

Hi @Suma Pralhad Kustagi,

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.

Query:

https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

Plugin:

https://marketplace.atlassian.com/search?hosting=server&product=jira&query=inactive%20user

Tom Lister_fo1j4e · Accepted Answer

Hi @Suma Pralhad Kustagi

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

https://github.com/listertuk/groovy/blob/main/server-dc/Scriptrunner/RemoveLicenseInactiveUsers.groovy