Open-AudIT

SELECT system.system_name, system.net_ip_address, network_card.net_mac_address, network_card.net_service_name, network_card.net_ip_enabled, network_card.net_dhcp_enabled, network_card.net_dns_server, network_card.net_dns_server_2, network_card.net_dns_server_3
FROM system INNER JOIN network_card ON (system.system_timestamp = network_card.net_timestamp) AND (system.system_uuid = network_card.net_uuid)
WHERE (((network_card.net_mac_address)<>"unknown") AND ((network_card.net_ip_enabled)="true") AND ((network_card.net_dhcp_enabled)="false"));