How to find the list of inactive users ?

[SANJEEV DAMERA]

How can i find the inactive users( who are part of only inactive projects) since six months using the sql query in JIRA?

[Udo Brand]

This is the same question as this one. As stated by Nic you should query the table CWD_USER.

[Tom Keidar]

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.

[Sam Omidi]

There is this KB here at https://confluence.atlassian.com/display/JIRAKB/Search+for+Inactive+Users

Cheers,

Sam 

[Sorin Sbarnea (Citrix)]

To get this fixed the right way, please add your comments to https://jira.atlassian.com/browse/JRA-29069

[Nic Brough -Adaptavist-]

Please see the duplicated thread you started - there's already more information there https://answers.atlassian.com/questions/146983/finding-the-inactive-users-with-respective-project

[SANJEEV DAMERA]

In order to get the list of inactive users since six months, I had a query to find the list of inactive projects. But i don't know how to fetch the list of users of a particular project using mysql query?

[codelab expert]

By default it is not possible to get this list in Jira using JQL. But you can write a groovy script using https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner.

I hope this will help you!