I am trying to query for the hostname of an IP Address? I have tried querying everything under IPAM.IPNode and cannot seem to find where the hostname is hiding????
Sorry- typed too fast. DNS would be dnsbackward.
I don't know if a simple hostname field except possible sysname but that is what the system reports as its name vs DNS. We manually enter a hostname into the alias field but you could easily setup a sql job to pull dnsbackward, remove domain and enter that into the alias field.
I thought it was DNSBY?
that looks like it is returning a number :
I queried for 1 ip and got dnsby: 16384
i queried another and got dnsby: 4
It seems that dnsbackward pulls what has been manually entered in the hostname field and sysname is what comes in from DNS.
CS