Level: minor

Purpose: Alert if a remote ticket is not created for an Active Alarm

Scenario: No remote ticket created for active alarm with active alarm create date between 1 day and 2 hours

Resolution: Find active alarm causing issue and search SnmpManager logs for why issue occurred.

Manual Action Steps: Watchdog Query

 SELECT COUNT(*)
 FROM active_alarm aa
       LEFT JOIN remote_ticket rt ON aa.id = rt.parent_id
       LEFT JOIN network_element ne ON ne.id = aa.network_element_id
       LEFT JOIN active_alarm_bounce aab ON aa.id = aab.active_alarm_id
 WHERE
aa.id >= (SELECT MIN(id) FROM active_alarm aa WHERE aa.created_date BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) AND DATE_SUB(NOW(), INTERVAL 2 HOUR))
AND aa.cleared_date IS NULL
AND ne.on_air IS TRUE
AND rt.id IS NULL
AND aa.acknowledged_date IS NOT NULL
AND aa.status NOT IN ('INFORMATION', 'WARNING')
AND aa.id NOT IN (SELECT aab2.active_alarm_id FROM active_alarm_bounce aab2 WHERE aab2.active_alarm_id IS NOT NULL)
AND aa.created_date BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) and DATE_SUB(NOW(), INTERVAL 2 HOUR);

Auto Clear: When watchdog query returns 0