...
| Code Block |
|---|
SELECT system.id AS `system.id`, system.type AS `system.type`, system.name AS `system.name`, system.domain AS `system.domain`, system.ip AS `system.ip`, nmap.first_seen AS `nmap.first_seen`, nmap.last_seen AS `nmap.last_seen`, nmap.port AS `nmap.port`, nmap.protocol AS `nmap.protocol`, nmap.program AS `nmap.program` FROM nmap LEFT JOIN system ON (nmap.system_id = system.id) WHERE @filter |
Return a list of all Modules installed on Routers
This example creates a list of all Modules marked as current='y' on devices of type 'router'
| Code Block |
|---|
SELECT system.id AS `system.id`, system.type AS `system.type`, system.name AS `system.name`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, module.description AS `module.description` FROM system LEFT JOIN module ON (module.system_id = system.id AND module.current = 'y') WHERE @filter AND system.type = 'router' ORDER BY system.name |