Our hostname, SolarWinds node name and DNS name are all different so I need a list of the SysName, NodeID and IP_Address so I can reconcile against a DNS export form the DNS server.
How do I create the report?
Matt
Will this work? In the end I want the SysName to equal the NodeID or Caption.
SELECT Caption, SysName, IP_Address FROM Nodes
WHERE((Caption <> SysName) AND (SysName <> ''))
ORDER BY Caption
!This query will update the node caption field to whatever value is currently in the sysname field.
!update nodes
set caption = sysname
where caption in (SELECT Caption FROM Nodes WHERE ((Nodes.Caption <> Nodes.SysName) AND (Nodes.SysName <> '')))
