cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

want alert if SNMP fails

Jump to solution

In NPM 12.1, a node details page had in the hardware details section, "Hardware polling failed: Error 31216 - SNMPv3 - Unknown UserName"

This state did not trigger an alert because the device was pingable.  How can I alert on this?

0 Kudos
1 Solution

You need to remove the 'SELECT Nodes.NodeID, Nodes.Caption FROM Nodes' part. The custom SQL query puts that part in automagically and doesn't let you change it.

View solution in original post

10 Replies

Could you PLEASE Post the Query.

0 Kudos

SELECT Nodes.NodeID, Nodes.Caption, Nodes.LastSystemUpTimePollUtc, Nodes.EngineID, ObjectSubType FROM Nodes WHERE DATEDIFF(s, Nodes.LastSystemUpTimePollUtc,GETUTCDATE())>660 and status =1

We had a similar issue recently where we had 1000+ WMI nodes failed but we didn't notice due to ICMP still working. Luckily all fixed now, rather than alert on it we've gone for a report based approach to keep an eye on it in the future.

The time difference on the report is set to 11 minutes as that aligns with our polling intervals better so we don't get false positives in the report, easily changed if needed though.

The SQL code does not validate in Solarwinds.  Has anyone got this to work in NPM 12.1?

SNMP_failure.jpg

0 Kudos

We have removed mentioned SELECT Nodes.NodeID, Nodes.Caption FROM Nodes but still same error is coming

we are gettting "Query condition is not valid " error message

0 Kudos

You need to remove the 'SELECT Nodes.NodeID, Nodes.Caption FROM Nodes' part. The custom SQL query puts that part in automagically and doesn't let you change it.

View solution in original post

We have removed mentioned SELECT Nodes.NodeID, Nodes.Caption FROM Nodes but still same error is coming

we are gettting "Query condition is not valid " error message

0 Kudos

We have removed mentioned SELECT Nodes.NodeID, Nodes.Caption FROM Nodes but still same error is coming

we are gettting "Query condition is not valid " error message

0 Kudos

Thank you very much.

0 Kudos