Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Sun Dec 15, 2019 7:34 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: Sat Mar 10, 2012 2:10 am 
Offline
Helper

Joined: Fri Aug 25, 2006 12:59 am
Posts: 75
Location: Northeast Pennsylvania
Is there a way in OA to get a list of computers generated by what DNS server they are using? I am phasing out a Linux DNS server and am hoping to use OA as a tool to determine what machines may have it as a static entry.

If I view an individual workstation's network card, the data is displayed for DNS entries. I can pull a CSV in MySQL if need be. I was just wondering if it was possible in OA.

Thanks!

_________________
Server: VM, 4GB RAM, 2 vCPU
Software: Server 2012 R2, OAE 1.6.2
Auditing: 350+ machines (W2K3, W2K8, W2K12, 7, 8, Vista, Linux)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Sat Mar 10, 2012 2:18 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
Quick and dirty. Filter results as appropriate.

Code:
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"));


Top
 Profile  
Reply with quote  
PostPosted: Tue Apr 24, 2012 1:23 am 
Offline
Helper

Joined: Fri Aug 25, 2006 12:59 am
Posts: 75
Location: Northeast Pennsylvania
Thank you for this. I was able to make some headway with the query script you gave me.

_________________
Server: VM, 4GB RAM, 2 vCPU
Software: Server 2012 R2, OAE 1.6.2
Auditing: 350+ machines (W2K3, W2K8, W2K12, 7, 8, Vista, Linux)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group