...
Code Block |
---|
{ "name" : "Devices Not Discovered", "sql" : "SELECT system.id AS `system.id`, system.type AS `system.type`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, system.owner AS `system.owner`, locations.name AS `locations.name`, locations.id AS `locations.id` FROM `system` LEFT JOIN `locations` ON system.location_id = locations.id WHERE @filter AND system.ip = ''", "description" : "Devices Imported but Never Seen by Discovery", "menu_display" : "y", "org_id" : 1, "menu_category" : "Device", "link" : "" } |
...
Devices Discovered Out of Contract
Code Block |
---|
{ "org_id" : 1, "menu_category" : "Device", "menu_display" : "y", "link" : "", "sql" : "SELECT system.id AS `system.id`, system.type AS `system.type`, system.ip AS `system.ip`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, DATE(system.last_seen) AS `system.last_seen`, system.end_of_service AS `system.end_of_service`, system.owner AS `system.owner`, locations.name AS `locations.name`, locations.id AS `locations.id` FROM `system` LEFT JOIN `locations` ON system.location_id = locations.id WHERE @filter AND system.ip != '' AND DATE(system.last_seen) > system.end_of_service", "name" : "Devices Discovered Out of Contract", "description" : "Devices that have been seen by discovery but whose end_of_service has expired." } |
...