SQL Sizzlers
Monday, October 21, 2019
Script to get SSRS reports start and end time
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment