...
| 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 |
|---|
{
"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.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."
} |
Discovered Inventory Report
| Code Block |
|---|
{
"link" : "",
"org_id" : 1,
"menu_category" : "Device",
"menu_display" : "y",
"description" : "Inventory details for discovered devices",
"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.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" : "Discovered Inventory Report"
}
|
Serial Numbers Not Found
| 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_category" : "Device", "org_id" : 1, "menu_display" : "y", "namedescription" : "Devices discovered Discoveredthat have Outno ofreported Contractserial", "sql" : "SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.manufacturerip AS `system.manufacturer`ip`, system.modelmanufacturer AS `system.model`manufacturer`, system.serialmodel AS `system.serial`model`, system.owneridentification AS `system.owner``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.ipserial != '' AND system.last_seen > system.end_of_service" }", "name" : "Devices Without Serial Numbers" |
Script
| View file | ||||
|---|---|---|---|---|
|