Script to get the start and end time of SSRS subscribed reports




To extract Start and end time of SSRS reports, you can run below query from SSMS on reportserverdb

/**************************************************/
SELECT
    C.[Name],
    C.ExecutionTime,
    MAX(EL.TimeStart),
    MAX(EL.TimeEnd)
FROM
    ReportServer.dbo.ExecutionLog AS EL JOIN
    ReportServer.dbo.[Catalog] AS C
        ON EL.ReportID = C.ItemID
GROUP BY
    C.[Name],
    C.ExecutionTime
/**************************************************/

No comments:
Write comments

Please do not enter spam links

Services

More Services