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>
Go

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

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

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:
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/60dd3392-42d8-4dc4-b8e6-15e9aeaad29e

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

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