TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?

Published 27 December 07 05:35 AM | SQL Master 

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

Comments

# Other SQL Server Blogs around the Web said on December 27, 2007 5:49 AM:

Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo

# SSQA.net - SqlServer-QA.net said on December 27, 2007 6:10 AM:

Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo

Anonymous comments are disabled

About SQL Master

**__________________________________** 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.