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