I am looking to find the table that contains the 'Network Interfaces' information under the 'Asset Inventory' for a node so I can query the DNS entries and run a quick report.
Thanks for any help you can give me on where to find these tables.
I am looking to find the table that contains the 'Network Interfaces' information under the 'Asset Inventory' for a node so I can query the DNS entries and run a quick report.
Thanks for any help you can give me on where to find these tables.
I think you are looking for the "Orion.AssetInventory.NetworkInterface" entity. With SWQL Studio you can query it like this:
SELECT NodeID, Name, IPAddress, IPv6Address, MACAddress, Manufacturer, Gateway, DHCPServer, Netmask, DNSServers, Alias, Type
FROM Orion.AssetInventory.NetworkInterface
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.