NetBotz Alert on Temperature Sensor

This produces no results. MIB and Row ID are correct. Numberic Value should produce a hit. Anyone see anything wrong with my logic?

SWQL

SELECT E0.[Uri], E0.[DisplayName]
FROM Orion.NPM.CustomPollerAssignmentOnNode AS E0
WHERE ( ( ( E0.[CustomPoller].[UniqueName] = 'tempSensorValueInt' )
      AND ( E0.[CustomPollerStatusScalar].[RowID] = '1023022' ) )
      AND ( ( E0.[CustomPollerStatusScalar].[RawStatus] < '28' ) )
      )

Find more posts tagged with

temperature sensor

temperature

Alert

hardware sensor

npm

Accepted answers

All comments

donrobert5

When you click on show list, you don't see any results?

monitoringlife

Edit: I pulled another example and custom node poller works fine. I'll leave the below as something to try. Would also try pulling the 'custom node poller, unique name' for your scoping.

If your pulling row ID you might want to switch to 'custom table poller current status'.

Here is one of mine

bobmarley

If you want to try a different way this is the code I use for a Custom SQL alert for custom pollers. Change the highlighted items so match your poller name and set the values you want in the Where clause. Note this is SQL, not SWQL.

WHERE CustomPollerAssignmentID IN (SELECT u.NetObjectID FROM (SELECT CustomPollerAssignment.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignment.AssignmentName AS Name
FROM (CustomPollerStatus INNER JOIN CustomPollerAssignment ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID))  LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID) /*SplitMarker*/ WHERE (CustomPollers.UniqueName = 'upsLoadCapacityPercentage') AND  
--added line below on 7-6-22 to prevent false alerts BobMarley  
(CustomPollerStatus.RawStatus NOT LIKE '%E+%') AND
(CustomPollerStatus.RawStatus >= 95)  AND
(CustomPollerStatus.RawStatus < 120)
) as u)