Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

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

Published Thursday, December 27, 2007 5:35 AM by SQL Master

Comments

# 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

Thursday, December 27, 2007 5:49 AM by Other SQL Server Blogs around the Web

# 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

Thursday, December 27, 2007 6:10 AM by SSQA.net - SqlServer-QA.net
Anonymous comments are disabled