Page History

{
   "linkorg_id" : ""1,
   "menu_displaycategory" : "yDevice",
   "orgmenu_iddisplay" : 1"y",
   "menu_categorylink" : "Device",
   "descriptionsql" : "DevicesSELECT thatsystem.id have been seen by discovery but whose end_of_service has expired.",
   "name" : "Devices Discovered Out of Contract",
   "sql" : "SELECT system.idAS `system.id`, system.type AS `system.type`, system.ip AS `system.ip`, system.manufacturer AS `system.id`manufacturer`, system.typemodel AS `system.type`model`, system.manufacturerserial AS `system.manufacturer`serial`, DATE(system.modellast_seen) AS `system.model`last_seen`, system.serialend_of_service AS `system.serial`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."
}