I want to get an alert when the delta for call counts between the two nodes reaches 50.

smsegin72

The following query below just displays the call count for two nodes.

SELECT E0.[Uri], E0.[DisplayName]
FROM Orion.NPM.CustomPollerStatusOnNodeTabular AS E0
WHERE ( ( ( E0.[CustomPollerAssignment].[CustomPoller].[UniqueName] = 'sonusGlobalCallCountStatusActiveCalls' ) ) AND ( ( E0.[RawStatus] >= '380' ) AND ( E0.[RawStatus] >= '80' ) ) )

Below are the call counts for each node. The DisplayName is the actual call count for each node.

To summarize, I would like to get an alert when the delta between the two nodes reaches 50.

Thank you!!!