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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: