SQL Server

Find SSRS subscriptions of an email address

I recently had the need to remove an email address from all SSRS subscriptions as a certain person was no longer with the company. Rather than weed through Report Manager or the emails you yourself receive (you do receive every report yourself, right?), you can run the following against ReportServer:

Our ReportServer database is actually ReportServer1. Keep that in mind.

I decided I wanted to take this a step further and remove this user from all subscriptions in one fell swoop, rather than manually configuring each and every subscription. The following Stored Procedure will allow you to run a read only or remove based on the email address passed. It takes into consideration that the email address may or may not have a following semi-colon ;

You can then run this Stored Procedure as follows:

I hope that helps!

Share on Google Plus

Mike250

Australian living. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf GTI. SQL Server Developer. Three sons. One daughter.

Leave a comment

Your email address will not be published. Required fields are marked *