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!