How can i find the inactive users( who are part of only inactive projects) since six months using the sql query in JIRA?
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!
This is the same question as this one. As stated by Nic you should query the table CWD_USER.
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?
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
To get this fixed the right way, please add your comments to https://jira.atlassian.com/browse/JRA-29069
There is this KB here at https://confluence.atlassian.com/display/JIRAKB/Search+for+Inactive+Users
Cheers,
Sam
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.
It looks like you're new here. Sign in or register to get started.
