I have found a few node names that appear in duplicate, but of course with different IP addresses. Not sure how this could happen unless someone adds an existing node manually. Any way, I would like to run a report using SWQL that could list any node names that are in the DB twice.
Any ideas how to write this?
something like this should display all the duplicate Captions with the IP Addresses assigned
select n.caption, n.IP_address from (select caption, count(caption) as [count] from orion.nodes group by caption having count(caption) > 1) a join Orion.Nodes n on a.caption=n.caption
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.