Checking SSRS Report Usage

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.