Saturday 15 July 2023

To check discoverer reports and run count

 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
;