data-konzept

'These days the request becoming quite common in many companies is to retire unused SSRS reports. This may take quite amount of time if you want to do this manually, especially in some companies dealing with hundreds of reports, organized under different sub folders. This article will provide a step-by-step guide to obsolete un-used reports programmatically by updating with custom message inside the report RDL’s.

Getting Started

In order to follow the examples, you will need to have SQL Server Reporting Services installed and configured. The code folder contains usagemetrics.sql, DummyReport.rdl, ObsoleteReportsFromFile.rss, and reports.txt file. 

Identifying Un-used Reports

SSRS Reports Usage metrics can be derived by Querying Report Server DB. Use the below T-SQL to derive the usage counts. If your report server is configured to store 1 year of reports execution history, we can use a specific date to filter the usage metrics. In my query I am checking all the metrics from the beginning of 2016.'...

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/155104/?utm_source=SSC&utm_medium=pubemail