How to get the filter subscription where certain group is used in the recipient list

[Abhijeet Kale]

In our Jira instance sometimes users create a filter subscription where some global groups like jira-users, jira-software-users, company-all, etc groups are used in the filter subscription and that sends a unnecessary emails to all the member of these groups that they don't need to take any action and also this cause the performance issues with the mail queue, so we want to setup some alerting when any global group is get added in the filter subscription so that we can check with those users and take necessary actions.

[Ravina · Accepted solution]

Hi @Abhijeet Kale Not sure which Jira environment you are using as its showing both Cloud and Jira Data Center, But if you are on Jira Data Center and have access to the Jira Database then you can use the below SQL query to identify the groups used in the filter subscription and it will also give you the filter id's, user who created it and what group is used in the recipient list.

I don't see there is any easy way to get this details for cloud instance if you using cloud envirenment.

select * from filtersubscription where groupname= 'jira-users';

select * from filtersubscription where groupname IN ('company-all', 'jira-users');

Based on the above SQL results you can create a scripting to get the alerts.

[Abhijeet Kale]

Thanks @Ravina this is helpful.