Discovering duplicate nodes

Does anyone know a sql query to determine if Orion has duplicate nodes in its database?

Thanks in advance

Find more posts tagged with

-- Display Any Duplicate Nodes
USE Netperfmon
Select IP_ADDRESS, count(*)
FROM NODES
GROUP BY IP_address
having COUNT (*)>1

HTH!

-- Display Any Duplicate Nodes
USE Netperfmon
Select IP_ADDRESS, count(*)
FROM NODES
GROUP BY IP_address
having COUNT (*)>1

HTH!

Thank you. This worked perfectly.

This is similar but I use this query in an APM component to generate an alert.

SELECT ISNULL(
    (SELECT
        1
    FROM
        Nodes
    GROUP BY
        IP_Address
    HAVING
        count(*) > 1
    ), 0) as duplicates