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



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:

Post a Comment