sql - SSRS Report last execution time for each report

Question

I have 75 SSRS reports and I need to get each report latest (max) executed DateTime. Could you please help me with this query?

question from:https://stackoverflow.com/questions/66067278/ssrs-report-last-execution-time-for-each-report

Answer 1

You can use the catalog and executionlog tables to get this information

SELECT 
    c.Name, c.[Path], MAX(e.TimeStart) as LastRun
 FROM ReportServer.dbo.Catalog c 
    join ReportServer.dbo.ExecutionLog e on c.ItemID = e.ReportID
GROUP BY c.name, c.[Path]