October 9, 2022 at 1:42 pm
hello guys
need to create SSRS report that shows execution run time for existing ssrs and subscription reports
Thanks
October 9, 2022 at 8:54 pm
What is your question?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 10, 2022 at 7:57 am
You can start here
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]
SQL 2000/2005/2008/2012 DBA - MCTS/MCITP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply