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