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

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

2 answers

1 accepted

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

This widget could not be displayed.

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

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

144 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you