Ray Barley's SSRS Notes
Tuesday, February 21, 2017
Get the last execution run time of every report
/*
SCRIPT: GET_LAST_REPORT_EXECUTION_TIME
get the last execution run time of every report
*/
SELECT
ItemPath
, MAX(TimeStart) RunTime
FROM [dbo].[ExecutionLog3]
GROUP BY ItemPath, TimeStart
ORDER BY 2 DESC
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment