Help with IPAM Report Writer

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'

;

Looks like you can do the same result without needing a custom SQL report.

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.

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! :-)