Hello Everyone,
I have created a uNDP for BGP Peer Status and it is returning values correctly. Now I need to create an alert if there is a 30% difference between the previous and current uNDP value.
Since SolarWinds does not provide this directly, I am trying a custom SWQL method. The challenge is that in the alert trigger condition, we cannot modify the SELECT query and can only work with the WHERE clause.
SELECT CustomPollerAssignmentID, AssignmentName, CustomPollerID, NodeID, DateTime, Rate, Total, RawStatus, Status, Description, RowStatus, RowID, DetailsUrl, DisplayName
FROM Orion.NPM.CustomPollerStatusOnNode
**************************************************************************************
WHERE CustomPollerStatusOnNode.CustomPollerID = '06caeb7d-32f9-41bb-a800-f120ff2f6572'
AND ABS(
(CustomPollerStatusOnNode.Status -
(
SELECT TOP 1 cpsd.DateTime
FROM Orion.NPM.CustomPollerStatus cpsd
WHERE cpsd.CustomPollerAssignmentID = CustomPollerStatusOnNode.CustomPollerAssignmentID
ORDER BY cpsd.DateTime DESC
)
) * 100.0 / NULLIF(
(
SELECT TOP 1 cpsd.DateTime
FROM Orion.NPM.CustomPollerStatus cpsd
WHERE cpsd.CustomPollerAssignmentID = CustomPollerStatusOnNode.CustomPollerAssignmentID
ORDER BY cpsd.DateTime DESC
),0)
) >= 30
but it’s not working as expected.
Has anyone implemented this type of alert condition for uNDP pollers, or can suggest the right SWQL approach?
Thanks in advance!
