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:
, 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!