...
Code Block |
---|
{ "link" : "", "org_id" : 1, "menu_category" : "Device", "menu_display" : "y", "description" : "Devices imported with a serial number that have not been 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.end_of_service AS `system.end_of_service`, system.end_of_life AS `system.end_of_life`, system.end_of_production AS `system.end_of_production`, system.maintenance_expires AS `system.maintenance_expires`, system.warranty_expires AS `system.warranty_expires`, 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 = ''", "name" : "Serial Numbers Not Found" } |
Devices Without Serial Numbers
Code Block |
---|
{
"link" : "",
"menu_display" : "y",
"menu_category" : "Device",
"org_id" : 1,
"description" : "Devices discovered that have no reported serial",
"name" : "Devices Without Serial Numbers",
"sql" : "SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.ip AS `system.ip`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.identification AS `system.identification`, 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.serial = ''"
} |