Archive for October, 2013

How can I find all reports that used a known data source

October 7, 2013

SELECT Catalog.path ,
cat1.Name datasource
FROM ReportServer.dbo.Catalog
JOIN ReportServer.dbo.DataSource ON Catalog.ItemID = DataSource.ItemID
JOIN ReportServer.dbo.Catalog cat1 ON DataSource.Link = cat1.ItemID
WHERE Catalog.Type = 2
AND cat1.Name = ‘DATASOURCENAME’

ORDER BY Catalog.Path

Advertisements