Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

want alert if SNMP fails

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?

Find more posts tagged with

Accepted answers

sum_giais

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.

All comments

sum_giais

Check this out...

Alert on node when ICMP is OK, but SNMP/WMI is DOWN - SolarWinds Worldwide, LLC. Help and Support

stantonb

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

sum_giais

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.

stantonb

Thank you very much.

itsashleykent

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.

Polling+Report.xml

gourav_baweja

Could you PLEASE Post the Query.

jayshree_vispute

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

jayshree_vispute

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

jayshree_vispute

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

ericmarshott

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