= 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)]]