Differences

This shows you the differences between two versions of the page.

--- resolution_area:watchdog_resolutions:res-w9105 [2021/06/25 10:09] – external edit 127.0.0.1
+++ resolution_area:watchdog_resolutions:res-w9105 [2021/07/06 16:25] (current) – 10.91.120.28
@@ Line 4: / Line 4: @@
-**Purpose:**
+**Purpose:** Alert if a remote ticket is not created for an Active Alarm
-**Scenario:**
+**Scenario:** No remote ticket created for active alarm with active alarm create date between 1 day and 2 hours
-**Resolution:**
+**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:**
+**Auto Clear:** When watchdog query returns 0

Internal Errigal Collaboration Wiki