/
opAddress 2.0 -> Open-AudIT 4.x Query for importing
opAddress 2.0 -> Open-AudIT 4.x Query for importing
For opAddress 2.0 we have changed the Open-AudIT import to use a query.
You will need a query named "opAddress" inside Open-AudIT for this to work as intended.
The standard query that will be shipped with the next release of Open-AudIT is below, but for those installing opAddress 2.0 and wanting Open-AudIT importing now, you should create a new query named opAddress and use the below SQL.
SELECT system.id AS `system.id`, system.ip AS `system.ip`, system.hostname AS `system.hostname`, system.sysName AS `system.sysName`, system.fqdn AS `system.fqdn`, system.dns_fqdn AS `system.dns_fqdn`, system.last_seen AS `system.last_seen`, network.speed AS `network.speed`, network.connection AS `network.connection`, ip.ip AS `ip.ip`, ip.mac AS `ip.mac`,ip.netmask AS `ip.netmask`, ip.network AS `ip.network`, ip.version AS `ip.version`, locations.name AS `locations.name` FROM ip LEFT JOIN system ON (ip.system_id = system.id AND ip.current = 'y') LEFT JOIN network ON (ip.net_index = network.net_index AND ip.mac = network.mac) LEFT JOIN locations ON (system.location_id = locations.id) WHERE @filter
, multiple selections available,
Related content
Release Notes for Open-AudIT v1.0.3
Release Notes for Open-AudIT v1.0.3
More like this
Release Notes for Open-AudIT v1.12.8.1
Release Notes for Open-AudIT v1.12.8.1
More like this
How to import NMIS Nodes and run discovery upon them (deprecated)
How to import NMIS Nodes and run discovery upon them (deprecated)
More like this
Blessed Subnets
Blessed Subnets
More like this
Open-AudIT v3.0.0 released
Open-AudIT v3.0.0 released
More like this
Release Notes for Open-AudIT v1.0
Release Notes for Open-AudIT v1.0
More like this