Query ReportServer Catalog for schema info of RDL reports

Question

I'm trying to get a list of all SSRS reports in the catalog and list their names and the xmlns attribute on the report element. I seem to be able to get the first attribute "MustUnderstand" and it's value, but can't seem to get the xmlns attribute and value.

Any help would be greatly appreciated.

Answer 1

Hi @Mark

You can use below tsql query statement :

 ;with CTE as (SELECT  
   [Path]  
 , CASE [Type]  
     WHEN 2 THEN 'Report'  
     WHEN 5 THEN 'Data Source'      
   END AS TypeName  
 , content = CAST(CAST(content AS varbinary(max)) AS xml)  
 , [Description]  
 FROM ReportServer.dbo.[Catalog] CTG  
 WHERE  
   [Type] IN (2, 5))  
   SELECT  [Path],TypeName,[xmlns] = content.value('namespace-uri((/*:Report)[1])','nvarchar(max)') from CTE  

Best Regards,
Isabella

Answer 2

Hi @Mark

You can use this tsql query statement to get the content of the report，then you can get the xmlns attribute

SELECT  
  [Path]  
, CASE [Type]  
    WHEN 2 THEN 'Report'  
    WHEN 5 THEN 'Data Source'      
  END AS TypeName  
, CAST(CAST(content AS varbinary(max)) AS xml)  
, [Description]  
FROM ReportServer.dbo.[Catalog] CTG  
WHERE  
  [Type] IN (2, 5);  

I refer to this thread：https://www.mssqltips.com/sqlservertip/6001/ssrs-reportserver-database-overview-and-queries/

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.