does anyone have a query against the ReportServer database that lists all reports by all the different data sources? I see that the data sources are listed in the Catalog table, but so are the reports. I dont know how to join the 2 together. Thanks!Craig

This works on 2005 and 2008 select c.name ReportName , d.name DataSourceName from dbo.catalog c inner join dbo.datasource d on c.itemid = d.itemid

That is the name of the data source in the report, not the report itself. also the name of the datasource in the report can differ from the data source name it inherited from. I am looking to find all reports that touch a certain serverCraig

That is the name of the data source in the report, not the report itself. also the name of the datasource in the report can differ from the data source name it inherited from. I am looking to find all reports that touch a certain serverCraig

Hi Craig, Gao.seng's reply suit for SSRS 2008 R2 as well, just type in below T-SQL in the database, you could get the report name and report's datasource name, here if you give AAA as the datasource name even if your shared datasource name is BBB, after execute the T-SQL, you will also get the AAA as datasource name. Please make sure your report has been deployed to the report server. select c.name ReportName , d.name DataSourceName from dbo.catalog c inner join dbo.datasource d on c.itemid = d.itemid If you want to get the global report source's name and path, please just type in below T-SQL select Path, Name from ReportServer.dbo.Catalog where Type = 5 Thanks,Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.