Does anyone know how to retrieve all attributes of an IPNode entry? For example, with a SWIS query I can't figure out how to retrieve (or set) the hostname attribute.
Does anyone know how to retrieve all attributes of an IPNode entry? For example, with a SWIS query I can't figure out how to retrieve (or set) the hostname attribute.
Hostname is stored in column DNSBackward in table IPAM.IPNode.
Sample query
SELECT TOP 1000 IpNodeId, IPAddress, DnsBackward
FROM IPAM.IPNode
WHERE DnsBackward is not NULL and DnsBackward <> ''
Sample result
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.