This is the same question as this one. As stated by Nic you should query the table CWD_USER.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is this KB here at https://confluence.atlassian.com/display/JIRAKB/Search+for+Inactive+Users
Cheers,
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To get this fixed the right way, please add your comments to https://jira.atlassian.com/browse/JRA-29069
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.