The SQL query below will list the number of generated alerts by control point. The query can be run from the SQL console or directly against the Assure database.
- Control Entity name
- Control Point name
- Number of alerts
SELECT PROCESSGROUP.NAME AS "Control Entity", PROCESSDEFINITION.DISPLAYNAME AS "Control Point", COUNT(*) AS "Number of Alerts"
FROM EXCEPTION INNER JOIN PROCESSDEFINITION ON PROCESSDEFINITIONFK=PROCESSDEFINITIONPK INNER JOIN PROCESSGROUP ON PROCESSGROUPFK=PROCESSGROUPPK
GROUP BY PROCESSGROUP.NAME, PROCESSDEFINITION.DISPLAYNAME
ORDER BY COUNT(*) DESC
Comments
0 comments
Please sign in to leave a comment.