Unable to find the owner for email subscription to delete them
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Multiple users are receiving emails from "Re: [JIRA] Subscription: ${searchRequest.getName()}"
Diagnosis
The issue occurs when the admin was unable to find the owner of the filter subscription nor the filter that was being used.
Solution
Click on the mail received for this subscription from the mailbox.
Right-click on "view source"(If you are using Outlook) and download the same. (Viewing the mail source might be different for different mailboxes. Please check the relevant for your mail client)
Check for the filter used in this subscription. You can find something similar to https://sitename.atlassian.net/issues/?filter=29413
To find the author of the filter, you can use the query below : (ID is retrieved from the Step 3)
1select * from searchrequest where id = 29413Now that you have the filter name, you can use the below SQL query below
1select * from filtersubscription where filter_i_d = 29413You will be able to find the username who created it and group_name to whom the subscription emails are being sent.
Under username you will see an ID of the user so to find the actual author, copy the username and use the below SQL to find the display name and details of user.
1select * from cwd_user where user_name = 'ug:xxxxxx-e7ae-4rjbd-y8e0-xxxxx'You can reach out to the username from the above to get the subscription deleted.
Was this helpful?