cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

SWQL query to show duplicate hostnames?

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?

0 Kudos
1 Reply

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

 

0 Kudos