This SQL query retrieves detailed execution logs from the ExecutionLog3 view in the SSRS ReportServer database. It shows when reports were run, who ran them, how long each phase (data retrieval, processing, rendering) took, the output format, execution status, and the size of the report output. It’s useful for monitoring report usage, performance, and troubleshooting issues with scheduled or interactive report runs.
You can customize it further by filtering for specific reports, users, or time ranges.
SELECT
InstanceName AS ReportServerInstance,
ItemPath AS ReportPath,
UserName AS ExecutedBy,
RequestType,
Format AS OutputFormat,
TimeStart AS ExecutionStartTime,
TimeEnd AS ExecutionEndTime,
TimeDataRetrieval AS DataRetrievalTimeMs,
TimeProcessing AS ProcessingTimeMs,
TimeRendering AS RenderingTimeMs,
Status,
ByteCount AS ReportSizeBytes,
[RowCount] AS RowsReturned
FROM
ExecutionLog3
ORDER BY
TimeStart DESC;