1 Reply Latest reply on Aug 9, 2010 10:01 AM by William_Powley

    How to Alert on a Duplicate IP in NPM


      Everyone in a while wehave someone add a duplicate IP to Orion. This ofcourse causes the polling engine to keel over every few hours. The only solution is to remove the offenting IPs.

      The query to find these IPs is:

      SELECT IP_Address, count(*)
      FROM Nodes
      GROUP BY IP_Address
      HAVING count(*) > 1

       But my question what would be the Alert conditions for and Advanced Alert to trigger?

      what would be the Custom query {$SELECT .....} to display the results?