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 commentsPlease do not enter spam links