=====AlarmsNotGeneratingRemoteTickets=====

**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