Find all SSRS Reports, Report Locations & Data Sources in ReportServer

Hi All,
sometimes opening ReportServer or Reports (Report Manager) takes a while. On the other hand querying database for information is faster than waiting for websites to respond.

Here is the quick way to check the number of SSRS reports deployed on report server, their locations (paths) and available data sources.

Use <Report Server Name>

List of available Reports & Their Locations
[Name] as [Report Name], [Path] as [Report Location]
From dbo.Catalog
Where [Name] <> ” and [Type] = 2
Order By [Name]

List of available Data Sources
[Name] as [Report Name], [Path] as [Report Location]
From dbo.Catalog
Where [Name] <> ” and [Type] = 5
Order By [Name]

Interesting fact about ReportServer database:
“We do not document or support querying any Report Catalog tables.  If you need to find out what items are in the report catalog, use the ListChildren SOAP API to list them.  We do support the ExecutionLog (Table/View; version dependent) or the ExecutionLog2 View.    Otherwise, writing queries against the SSRS DB is not supported and the schema, content, interpretation of the content is subject to change without notice.”

You can check this thread here:

Type column values in dbo.Catalog table
(Note: Information mentioned in below table is not validated by Microsoft.)

Type Description
1 Folder
2 Report
3 Resource
4 Linked Report
5 Data Source
6 Report Model
7 Report Part (SQL 2008 R2)
8 Shared Dataset (SQL 2008 R2)

I will post more on SSRS internals in my later posts.
Thanks, Khilit

5 (100%) 1 vote


Leave a Reply