Hi,
I have a problem here with DNS lookup. I have a list of servers and their IP address in a lookup file, say serverlist.csv. I have a separate set of DNS in a lookup file say DNS.csv. I want to compare whether the serverA has same IP address both in my serverlist.csv and DNS.csv. If the IP address for serverA is the same in both sheets, then that's fine, but if it's different in both sheets, then it must display result as "IP address does not match". I tried the searches below, but not getting a proper result.
|inputlookup serverlist.csv | eval ipaddress=ip |eval Server_Name=fqdn | lookup DNS servername OUTPUT fqdn, ipaddr | where
ipaddress!=ipaddr OR Server_Name!=fqdn | table Server_Name, fqdn, ipaddr
Is there any other way to do it?
... View more