Queries on Inactive user's permission and total count of watcher's list and mailing list.

[Nithin CK]

Hi,

I have below mentioned queries:
1. How to make bulk users inactive ?
2. How to filter out and get the exact count of Inactive users ?
3. How to filter out and get the total count of users who were only watchers (Every mail address in CC list will be added to watcher's list) and never a reporter ?
4. How to filter out and get the total count of mailing list users (i.e., mail group address which were automatically added as a user) and never logged in ?

Best Regards,
Nithin CK

[Radu Dumitriu · Accepted solution]

Check this out: http://confluence.kepler-rominfo.com/display/RDNA10/Other+Sanity+ChecksThe plugin is called RightsDNA and you can find it here: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.rightsdna

[Nithin CK]

Hi Radu,

Thanks for that plugin and it satisfies couple of my requirements like Number of non-recorded users and deactivated users but when i try to deactivate an user via that plugin it doesnt really deactivate the user.

So if someone can provide the SQL queries or a better plugin then it will be of much help.

Best Regards,

Nithin CK

[Taiwo Akindele]

1. How to make bulk users inactive ?

Currently not possible, you may watch and vote up on this feature request here: https://jira.atlassian.com/browse/JRA-30708

2. How to filter out and get the exact count of Inactive users ?

You can get this information from the cwd_user table in the JIRA database, the column of interest would be 'active'. But then it depends on your JIRA version, de-activating users was quite different and not as simple in versions prior to JIRA 5.2 (or thereabout)

For the rest of your questions probably it may be slightly different depennding on the schema for your JIRA version as well. You may see if this gives you some general idea on how to start:

https://developer.atlassian.com/display/JIRADEV/Database+Schema

[Nithin CK]

Hi Taiwo,

Thanks for the answers.

I am using Jira 6.1.1 on Linux machine. If possible can you provide me the sql queries for those queries ? I am new to SQL and not good at query writing.

Best Regards,

Nithin CK