Post reply

SSRS report execution details

  • 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

  • October 9, 2022 at 8:54 pm

    #4097229

    What is your question?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply