JQL for inactive users since one month

[Suma Pralhad Kustagi]

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 solution]

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 · Accepted solution]

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

[Sanjog Sigdel]

@Suma Pralhad Kustagi  There isn't a default Jira Query to fetch inactive users. However you can do that via database query or any marketplace apps.