SQL Queries - CAST Central Base - Queries on Metrics - How to detect when the violation has been added into the Action Plan

SELECT   ap.First_snapshot_date,
         COUNT(1)
FROM     VIEWER_ACTION_PLANS ap,
         DSS_OBJECTS visible             ,
         DSS_SNAPSHOTS s
WHERE    ap.OBJECT_ID + 0 = visible.OBJECT_ID
AND      s.FUNCTIONAL_DATE BETWEEN ap.FIRST_SNAPSHOT_DATE AND      ap.LAST_SNAPSHOT_DATE
AND      s.SNAPSHOT_ID = <snapshot_id>
AND      EXISTS
         (SELECT 1
         FROM    c735_2592_asd.DSS_METRIC_RESULTS dmr,
                 c735_2592_asd.DSS_METRIC_TYPE_TREES dmtt
         WHERE   dmtt.METRIC_PARENT_ID = ap.METRIC_ID
         AND     dmtt.METRIC_ID        = dmr.METRIC_ID
         AND     dmr.OBJECT_ID         = ap.OBJECT_ID
         AND     dmr.SNAPSHOT_ID       = <snapshot_id>
         )
GROUP BY ap.First_snapshot_date
ORDER BY ap.First_snapshot_date

Same as that for CSS

Same as that for CSS