How to find the list of inactive users ?

SANJEEV DAMERA March 12, 2013

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

7 answers

1 vote
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2013

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

0 votes
Tom Keidar February 10, 2020

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.

0 votes
Sam Omidi November 18, 2015
0 votes
Sorin Sbarnea (Citrix)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 4, 2014

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

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 12, 2013

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

0 votes
SANJEEV DAMERA March 12, 2013

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?

0 votes
codelab expert
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2013

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!

Suggest an answer

Log in or Sign up to answer