I've created a custom alert to send e-mails and NetPerfMon entry when my F5 Pool is in down status. The trigger condition SQL is:
Select Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
From Nodes
Where Nodes.NodeID in (Select F5_Pools.NodeID From F5_Pools Where F5_PoolsAvailabilityStatus = 3 AND F5_PoolsEnabledState = 1 AND F5_PoolsName Like '/Common/Prod%')
The alert works fine it's the reset that doesn't work. I've tried reset conditions: Reset when trigger conditions are no longer true and
Select Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
From Nodes
Where NOT Nodes.NodeID in (Select F5_Pools.NodeID From F5_Pools Where NOT F5_PoolsAvailabilityStatus = 3 AND F5_PoolsEnabledState = 1 AND F5_PoolsName Like '/Common/Prod%').
I'm wondering if:
Select Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
From Nodes
Where Nodes.NodeID in (Select F5_Pools.NodeID From F5_Pools Where F5_PoolsAvailabilityStatus = 1 AND F5_PoolsEnabledState = 1 AND F5_PoolsName Like '/Common/Prod%')
would be a better option?