Greetings all!
I am trying to set up a Custom SQL Alert for a Custom Node Poller with no luck. When I modify the query in SSMS to guarantee one returned record, I get nothing in SolarWinds. I'll attach the real trigger condition and the modified condition that guarantees at least one returned record.
Original query:
[GIVEN SELECT]
SELECT CustomPollerAssignmentView.AssignmentName, CustomPollerAssignmentView.CustomPollerAssignmentID FROM CustomPollerAssignmentView
[CUSTOM]
LEFT OUTER JOIN (
SELECT NodeID, COUNT(*) AS 'ProcCount'
FROM AssetInventory_ProcessorView
GROUP BY NodeID
) AS procs ON CustomPollerAssignmentView.NodeID = procs.NodeID
WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min'
AND CONVERT(decimal,CustomPollerAssignmentView.CurrentValue) < procs.ProcCount
Modified to guarantee at least one returned record:
[GIVEN SELECT]
SELECT CustomPollerAssignmentView.AssignmentName, CustomPollerAssignmentView.CustomPollerAssignmentID FROM CustomPollerAssignmentView
[CUSTOM]
LEFT OUTER JOIN (
SELECT NodeID, COUNT(*) AS 'ProcCount'
FROM AssetInventory_ProcessorView
GROUP BY NodeID
) AS procs ON CustomPollerAssignmentView.NodeID = procs.NodeID
WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min'
It's strange because if I just use WHERE CustomPollerAssignmentView.CustomPollerName LIKE 'LoadAverage1min', no alerts are triggered. Is this method of alerting not working as expected, or am I misconfiguring it?
Thanks in advance!
Jack Vaughan, Jr.
Systems Monitoring Engineer
___________________________
CONNECTRIA HOSTING
___________________________
NO JERKS ALLOWED
www.connectria.com
Connectria Blog
Recommend us on Linkedin
Follow us on Twitter