Skip to content

Instantly share code, notes, and snippets.

@jeremykdev

jeremykdev/ReportSubscriptionByEmailAddress.sql

Created April 22, 2014 21:28
Show Gist options
  • Save jeremykdev/11195008 to your computer and use it in GitHub Desktop.
Save jeremykdev/11195008 to your computer and use it in GitHub Desktop.
Download ZIP
Query to find reports which are scheduled to be send to a given email address using a subscription in Microsoft SQL Server Reporting Services..
Raw
ReportSubscriptionByEmailAddress.sql
USE ReportServer;
SELECT C.Path
FROM dbo.Subscriptions AS S
INNER JOIN dbo.Catalog AS C
ON ( S.Report_OID = C.ItemID )
WHERE ExtensionSettings LIKE '%[email protected]%'
ORDER BY C.Path;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment