Printer Low Supply Warning
Configuration
severity
ok
Rule Query
sql SELECT * FROM devices,device_group_device,device_groups,devices_group_perms,users,notifications_attribs,notifications,toner WHERE (devices.device_id = ? AND devices.device_id = device_group_device.device_id AND device_group_device.device_group_id = device_groups.id AND device_groups.id = devices_group_perms.device_group_id AND devices_group_perms.user_id = users.user_id AND users.user_id = notifications_attribs.user_id AND notifications_attribs.notifications_id = notifications.notifications_id AND devices.device_id = toner.device_id) AND (devices.status = 1 (devices.disabled = 0 devices.ignore = 0)) = 1 AND toner.toner_current < 30 AND toner.toner_current > 0 AND toner.toner_capacity > toner.toner_current AND notifications.datetime > DATE_SUB(NOW(),INTERVAL 5 DAY) AND toner.toner_descr NOT LIKE 'Tray' AND toner.toner_descr NOT LIKE 'Stack' AND toner.toner_descr NOT LIKE 'Drawer'