Device Sensor State Critical Non Printers
Server Sensor Monitoring
notes
Wireless Sensor Monitoring
Appliance Sensor Monitoring
Configuration
severity
warning
Rule Query
sql SELECT * FROM devices,device_group_device,device_groups,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = device_group_device.device_id AND device_group_device.device_group_id = device_groups.id AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value state_translations.state_generic_value = 2) = 1 AND (devices.status = 1 (devices.disabled = 0 devices.ignore = 0)) = 1 AND sensors.sensor_alert = 1 AND devices.type != Printer AND sensors.sensor_descr != Routing Engine AND sensors.sensor_descr != Yellow Alarm AND sensors.sensor_prev IS NOT NULL AND sensors.sensor_prev != 0 AND device_groups.id != 7 AND devices.hostname != ip-192-168-1-117.ec2.internal AND devices.poller_group != 266 AND devices.hostname != ip-10-1-1-1.coch.nms