
 January 6, 2015 05:34 by 
 Peter
 Peter
This can be a decent administrator device to screen all reports create on SSRS case and it can be helpful particularly if the rundown of your reports is getting huge.  It's a basic question on "Reportserver" database which can be once in a while named differently much the same as mine is: "Reportserver$mike" (named occasions), yet for SSRS introduced on default case it ought to be this one from beneath: 

USE [ReportServer]
 GO
 SELECT 
   Name,
   [Path]
   --,[Description]
 FROM [dbo].[Catalog]
 WHERE [Type] = 2
 ORDER BY [Path]
 
 Result:
 Name Path
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AdventureWorks_Base /AdventureWorks/AdventureWorks_Base
 Customers_Near_Stores /AdventureWorks/Customers_Near_Stores
 Employee_Sales_Summary /AdventureWorks/Employee_Sales_Summary
 Sales_by_Region /AdventureWorks/Sales_by_Region
 Sales_Order_Detail /AdventureWorks/Sales_Order_Detail
 Store_Contacts /AdventureWorks/Store_Contacts
 (6 row(s) affected)
 
 Likewise, here is a little extensio for the query which I want to utilize this one with guardian envelope structure included: 
 USE [ReportServer]
 GO
 SELECT 
   Name,
   FullPath = [Path]
   ,ReportParentPath = REVERSE(SUBSTRING(REVERSE(Path), CHARINDEX('/', REVERSE(Path)), LEN(REVERSE(Path))))
   --,[Description]
 FROM [dbo].[Catalog]
 WHERE [Type] = 2
 ORDER BY [Path]
 
 For more extensive checking contemplations I prescribe probably the most vital tables in Reportserver database: USE [ReportServer]
 GOSELECT * FROM [Catalog]
 SELECT * from [dbo].[DataSets]
 SELECT * FROM [dbo].[DataSource]
 SELECT * FROM [dbo].[Users]