Create Alert by Comparing Status of 2 IP's

johnwilly

Hi All,

I Would like to generate an Alert if 2 IP's are down at the same time. and Reset once both the IP's are UP again. The Alert should not generate if only 1 IP goes down.

Please do help me with Trigger and Reset Conditions.

Thanks

vinay.by

You can achieve  this by a Cutom SQL Alert in your Advanced Alert Manager

Type of property to monitor : Custom SQL Alert

Set up your trigger Query: Node

Use the below query in your alert:

WHERE

(

  (Nodes.Status = '2') AND

  (Nodes.IP_Address = '10.X.X.1')

)

AND EXISTS (SELECT

Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, Nodes.Status AS Status

FROM

Nodes

WHERE

(

  (Nodes.Status = '2') AND

  (Nodes.IP_Address = '10.X.X.2')

))

Note :

1. In the above query I have used '10.X.X.1' and '10.X.X.2' modify them accordingly.

2. The alert would get triggered from '10.X.X.1' if both the IP's are down.

3. If you want to reset the alert if both IP's are UP , under Reset Condition select - Reset this alert when following condition 's are met, use the same query above but modify Nodes.Status to 1 [Change (Nodes.Status = '2') to (Nodes.Status = '1')]