SSRS Last Run Report Name - Finding

Objective:


To find the last run report on SSRS.


Query to Execute on Report Database:


SELECT TOP (1) PERCENT
ReportPath,
TimeStart,
TimeEnd,
UserName,
RequestType,
Format,
TimeDataRetrieval,
TimeProcessing,
TimeRendering,
[Source]


FROM

dbo.ExecutionLog2


WHERE
(ReportPath = N'/Report Project1/Report1') --- Path of the report


ORDER BY
TimeStart DESC