Cisco temperature alert

Questionario

Just thought I would share this:

We have created an alert to email us when a cisco device says it has a "warning" temperature. This temperature is decided by the device itself but the actual temperature is also returned within the alert email.

We have assigned 2 UnDP's for this (1.3.6.1.4.1.9.9.13.1.3.1.3 and 1.3.6.1.4.1.9.9.13.1.3.1.6) to every cisco device we want to monitor.

The trigger condition is just like this:

---
Trigger when all conditions apply:
OID is equal to 1.3.6.1.4.1.9.9.13.1.3.1.6
Status is greater than 1
---

Reset Condition:
---
Reset when all conditions apply:
OID is equal to 1.3.6.1.4.1.9.9.13.1.3.1.6
Status is equal to 1
---

Within the email you can use the following to return the temperature in degrees celsius:

---
${SQL:SELECT CustomPollerStatus.Status FROM dbo.CustomPollers INNER JOIN dbo.CustomPollerAssignment ON dbo.CustomPollers.CustomPollerID = dbo.CustomPollerAssignment.CustomPollerID INNER JOIN dbo.CustomPollerStatus ON dbo.CustomPollerAssignment.CustomPollerAssignmentID = dbo.CustomPollerStatus.CustomPollerAssignmentID WHERE CustomPollerAssignment.NodeID =  ${NodeID} AND CustomPollers.OID = '1.3.6.1.4.1.9.9.13.1.3.1.3'}°C
---

This alerts when the cisco device thinks that it reached a threshold (which is different for each model) and then also return the actual temperature within the email.

nelsonc0

That is much simpler than my way I think I used the custom pollers ciscoEnvMonTemperatureThreshold and ciscoEnvMonTemperatureStatusValue

Comparing the status against the threshold.

The only thing I would suggest is using the RawStatus column vs. the status column. They hold the same information for the most part, but if you are joining the nodes table at the same time then you have to clarify which table you want the status pulled from, where raw status is unique to the custompollerstatus table.