Do you want to have all reports that used a table in their report definition?
Are you looking for a report that has a desired parameter name?
Have you written a new version of a SQL view or stored procedure and you need to modify all the reports working on top of the version of the object, but, you don’t know what those reports are?
Have you modified an SSAS object and you need to know which reports might be affected?
If you have any of the above questions or in general you need to retrieve all SSRS reports which have a specific string in their report definition, just connect to the SQL Server instance which holds your REPORTSERVER database through SSMS and simply execute the SQL scripts below:
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%’
Enjoy!
