sp_BlitzRS® Result: E-mail Accounts with Subscriptions

There are three scenarios where Reporting Services can tie e-mail addresses to a subscription:

1. Standard subscription with static e-mail addresses.
2. Data-driven subscription with static e-mail addresses.
3. Data-driven subscription with dynamic e-mail addresses determined by query output.

sp_BlitzRS® will dig into the ReportServer database and list all the distinct e-mail addresses it finds in scenarios 1 & 2. This is really handy information to have when, for example, an employee leaves and their replacement needs to get the same report but sent to their own account.

The third scenario — a data-driven subscription with dynamic recipients — can’t be reliably reported on because the data source may not be accessible to sp_BlitzRS®. (This can happen when the username/password to access the data source has different permissions from the current user or SQL Server Service Account.)

When reading sp_BlitzRS®, keep in mind any subscriptions with dynamic recipients won’t be mentioned.