Tuesday, June 30, 2015

List all SSRS subscription with description

SELECT c.Name,c.Path,s.Description
FROM dbo.Subscriptions s
INNER JOIN dbo.Catalog c ON s.Report_OID = c.ItemID

No comments:

Post a Comment