At work, I recently was asked whether some reports were still in use. These are SQL Server Reporting Services reports, so fortunately there’s an easy way to find that out. Go to the SQL Server instance hosting Reporting Services and go to the ReportingServices database. Then, the following query will get reports run over the past week:
SELECT el.ReportPath, SUM(CASE WHEN el.RequestType = 'Interactive' THEN 1 ELSE 0 END) AS Interactive, SUM(CASE WHEN el.RequestType = 'Subscription' THEN 1 ELSE 0 END) AS Subscription FROM dbo.ExecutionLog2 el WHERE el.TimeStart > DATEADD(WEEK, -1, GETUTCDATE()) GROUP BY el.ReportPath ORDER BY el.ReportPath;
This also breaks out interactive report requests versus subscriptions to see if people are seeking out these reports or if you’re pushing them.