TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
Use ReportServer
Go
SELECT
DS.Name as DataSourceName, CT.Name AS ItemName, CT.Path
FROM
dbo.Catalog CT INNER JOIN
dbo.DataSource DS ON CT.ItemID = DS.ItemID
Where Type=2
Order by DataSourceName,ItemName
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.