Querying SSRS Report Definition in SSMS


Do you wish to have all studies that used a desk of their report definition?

Are you searching for a report that has a desired parameter title?

Have you ever written a brand new model of a SQL view or saved process and it’s essential to modify all of the studies engaged on prime of the model of the thing, however, you don’t know what these studies are?

Have you ever modified an SSAS object and it’s essential to know which studies could be affected?

You probably have any of the above questions or typically it’s essential to retrieve all SSRS studies which have a selected string of their report definition, simply hook up with the SQL Server occasion which holds your   REPORTSERVER database via SSMS and easily execute the SQL scripts beneath:

SELECT C.NAME

       , CONVERT(NVARCHAR(MAX),CONVERT(XML,CONVERT(VARBINARY(MAX),C.CONTENT))) AS REPORTXML

FROM  REPORTSERVER.DBO.CATALOG C

WHERE  C.CONTENT IS NOT NULL

            AND  C.TYPE = 2

          –AND  C.NAME LIKE ‘%REPORT_NAME%’

     AND CONVERT(NVARCHAR(MAX),CONVERT(XML,CONVERT(VARBINARY(MAX),C.CONTENT))) LIKE ‘%DESIRED_STRING%’

Take pleasure in!



Supply hyperlink

Leave a Reply

Your email address will not be published. Required fields are marked *