Labels

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