SSRS Report Run History

The following query shows report history for a report name (Employee Attendance Report) in the WHERE clause. This is a great way to check what parameters are used and how often the report is being called.

select
[InstanceName]
, [ReportPath]
, [UserName]
, [ExecutionId]
, [RequestType]
, [Format]
, [Parameters]
, [ReportAction]
, [TimeStart]
, [TimeEnd]
, [TimeDataRetrieval]
, [TimeProcessing]
, [TimeRendering]
, [Source]
, [Status]
, [ByteCount]
, [RowCount]
, [AdditionalInfo]
FROM ExecutionLog2
Where ReportPath like '% Employee Attendance Report %'
Order by TimeStart desc