Query to find reports which are scheduled to be send to a given email address using a subscription in Microsoft SQL Server Reporting Services..

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 '%target@example.com%' 
ORDER BY C.Path;