Search SSRS Reports for Keywords

Microsoft’s SQL Server Reporting Services, colloquially known as SSRS, provides a great way to expose data from SQL Server in human-consumable form, typically via a web site. Generally, it’s a good idea to use a stored procedure as the source of data for SSRS Reports. In a large SSRS environment, it can be challenging to determine which reports use a specific stored procedure.

This code provides details about SSRS Reports where the definition of the report includes any specific keyword, such as the name of a stored procedure.

Fashion Plate (Walking Dress) by John Bell, 1822

Fashion Plate (Walking Dress) by John Bell, 1822

You’ll need access to the ReportServer database to run this code.

Thanks for visiting our site, and be sure to check out the other tools we’ve made available.