Find Top 20 SSRS Reports Run Over the past 30 days

Clearinghouse Repository Polaris Repository
1

Finds the top 20 most executed SSRS reports run over the past 30 days. MUST be run from your SSRS report server.

SELECT TOP 20
    CASE 
        WHEN ItemPath IS NULL THEN 'Unknown/Ad-Hoc' 
        ELSE ItemPath 
    END AS ReportPath,
    COUNT(*) AS ExecutionCount,
    MAX(TimeStart) AS LastRunDate
FROM reportserver.dbo.ExecutionLog3
WHERE TimeStart >= DATEADD(DAY, -30, GETDATE())
  -- Optional: Uncomment the line below to only show reports that ran successfully
  -- AND Status = 'rsSuccess'
GROUP BY ItemPath
ORDER BY ExecutionCount DESC;

For more SSRS stats, see: Query SSRS Report Execution Log