Search this blog

Friday, February 15, 2013

Lists All SSRS Reports & Datasources

The following SQL Scripts helps you to list out all the reports with associated Data-sources which are all deployed at Microsoft Reporting server(SSRS)

Use ReportServer

SELECT
      Catalog.Name AS ReportName,
      Catalog.path AS Report_Location,
      DataSource.Name AS DataSourceName
FROM
      [Catalog] INNER JOIN DataSource
            ON Catalog.ItemID = DataSource.ItemID
order by Catalog.path

Hope this Helps!

No comments:

Post a Comment