SSRS report execution details

• danssms

  SSC Enthusiast

  Points: 193

  More actions

  October 9, 2022 at 1:42 pm

  #4097156

  hello guys

  need to create SSRS report that shows execution run time for existing ssrs and subscription reports

  1. report name
  2. report type ( adhoc or subscription report )
  3. report run time in seconds
  4. report owner
  5. report owner permission level
  6. report run by

  Thanks

• Phil Parkin

  SSC Guru

  Points: 246959

  More actions

  October 9, 2022 at 8:54 pm

  #4097229

  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

• Kenny Jozi

  SSCrazy

  Points: 2028

  More actions

  October 10, 2022 at 7:57 am

  #4097337

  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