Hostname as in dnsbackward?
Here's a custom SQL that should work
(assuming you wanted subnet location vs node snmp location?) :
SELECT i.IPAddress,g.addressMask, i.dnsbackward, g.Location, i.Description, i.Vendor
FROM IPAM_Node i
inner join IPAM_group g on i.subnetid=g.groupid
where i.dnsbackward is not null and
i.dnsbackward <>'' and
i.dnsbackward like '%.domain.com'
This was the easiest method and worked like a charm. The Reverse DNS was the key here. I was searching for "Hostname" and completely ignored that Reverse DNS...
Thank you so much, you just made my life a lot easier! :-)
1 of 1 people found this helpful
Can you tell I have off work this afternoon
Here's the custom resource version -
pro - is it is quick to add to any site and modify when needed and it groups into any number of nodes per page you want
con - unlike the above report you cannot make the IP address and/or hostname clickable to the IP Node details page.