I'm trying to do something that I think should be fairly basic but, I am failing miserably at. I have an APC UPS that I want to alert on if one of two conditions exist.
1. upsBasicBatteryStatus != batteryNormal(2)
OR
2. upsAdvInputLineVoltage < 115
I'm basically trying to do this
SELECT CurrentValue, CustomPollerDescription, CustomPollerName, Status, StatusDescription
FROM Orion.NPM.CustomPollerAssignmentOnNode
WHERE NodeID = 5606
AND (CustomPollerName = 'upsBasicBatteryStatus' AND CurrentValue != 'batteryNormal(2)')
OR (CustomPollerName = 'upsAdvInputLineVoltage' AND CurrentValue < '115')
For the life of me I cannot seem to configure a working alert trigger. How do I add an OR condition so it triggers if either condition is met?
In fact, even with a basic trigger like upsAdvBatteryCapacity < 95, the alert will trigger even though the capacity is 100.


