Inverse trigger dependency? monitoring active / passive services ?

[sysadm.es]

In case of active / pasive cluster of SQLServer for example, with two nodes.
Node1: has the services of SQLServer running
Node2: Has the services of SQLServer stopped
How can ignore the Node2 stopped trigger if the trigger is running up on the Node1?
Which is the right way in this cases ?

[isaqueprofeta]

First, put your single reference triggers for each host in severity: Information

Then, you can do a single trigger with dependency between hosts for the service, and in this one, you can use an "and" logic like:

{main_server:net.tcp.service[,,1433].last()}=0 and {backup_server:net.tcp.service[,,1433].last()}=0

The above example will only trigger an event if both servers are down, and should be a High or Disaster level of severity.

[sysadm.es]

First, put your single reference triggers for each host in severity: Information

Then, you can do a single trigger with dependency between hosts for the service, and in this one, you can use an "and" logic like:

{main_server:net.tcp.service[,,1433].last()}=0 and {backup_server:net.tcp.service[,,1433].last()}=0

The above example will only trigger an event if both servers are down, and should be a High or Disaster level of severity.

You are right, it is the most logic, also i have the data through the floating IP.

Thanks.

Kind regards.