Changes between Initial Version and Version 1 of Cnbp2019/Agenda/LibreNMSAlertrules

Timestamp:

Mar 7, 2019, 4:30:21 PM (6 years ago)

Author:

admin

Comment:

--

Cnbp2019/Agenda/LibreNMSAlertrules

@@ +1 @@
+= Alert rules- Practicals =
+
+1.      Verify whether '''pc1''' is '''down''' or '''up'''
+2.      Check whether '''pc6 memory usage > 50%'''
+3.      Find the devices where the '''CPU usage >=90'''
+
+>Note : Configure to send email in above scenarios
+
+== Answers ==
+
+1.
+{{{#!sql
+SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.disabled = 0 && devices.ignore = 0) = 1 AND devices.status = 1
+}}}
+[[Image(Alert1.png,85%,border=1, center)]]
+2.
+{{{#!sql
+SELECT * FROM devices,mempools WHERE (devices.device_id = ? AND devices.device_id = mempools.device_id) AND (devices.status = 1 
+&& (devices.disabled = 0 && devices.ignore = 0)) = 1 AND mempools.mempool_perc >= 90 AND mempools.mempool_descr REGEXP "Virtual.*"
+}}}
+[[Image(Alert2.png,85%,border=1, center)]]
+3.
+{{{#!sql
+SELECT * FROM devices,processors WHERE (devices.device_id = ? AND devices.device_id = processors.device_id) AND 
+(devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND processors.processor_usage >= 90
+}}}
+[[Image(Alert3.png,85%,border=1, center)]]