Sql Query to check list of all discoverer reports and a run count:
SELECT STAT.QS_DOC_NAME,
STAT.QS_DOC_OWNER,
MAX(STAT.QS_CREATED_DATE),
COUNT(1)
FROM EUL_US.EUL5_QPP_STATS STAT
GROUP BY STAT.QS_DOC_NAME,
STAT.QS_DOC_OWNER
ORDER BY MAX(STAT.QS_CREATED_DATE) DESC
;
No comments:
Post a Comment