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

How to create a report to identify nodes using SNMP for Status & response times

Morning, I'm looking into finding out how to find out any nodes using SNMP for status and response time. I mean the tick under list resources and not polling method under node. Any ideas or suggestions would be gratefully accepted, as I've hit a road block.

Find more posts tagged with

Comments

fop

Apologies for the scrappily formatted query, but this digs out that info. I've not worked out the significance of the 'enabled' column yet though, it's showing some of our nodes as disabled but looking at the List Resources it's very much active.

SELECT p.PollerID, n.Caption, p.PollerType, p.NetObjectID, p.Enabled FROM Orion.Pollers p INNER JOIN orion.nodes n on n.nodeid = p.netobjectid where p.PollerType like 'n.details.snmp.generic'

Might give you some clues for further investigation. I haven't yet found what table has those poller definitions in.

bobmarley

I don't have any of that node type to test but try this:

SELECT n.NodeID, n.Caption, n.IPAddress, p.PollerTypeFROM Orion.Nodes nJOIN Orion.Pollers p ON p.NetObjectID = n.NodeIDWHERE p.PollerType IN ( 'N.Status.SNMP', 'N.ResponseTime.SNMP')ORDER BY n.Caption

bobmarley

The opposite query, nodes using ICMP

SELECT n.NodeID, n.Caption, n.IPAddressFROM Orion.Nodes nSELECT n.NodeID, n.Caption, n.IPAddressFROM Orion.Nodes nWHERE n.NodeID NOT IN ( SELECT NetObjectID FROM Orion.Pollers WHERE PollerType IN ( 'N.Status.SNMP', 'N.ResponseTime.SNMP' ))ORDER BY n.Caption

naveensingh43

Node Not Responding to Agent / SNMP / WMI

SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes<br/>WHERE Nodes.Status IN(1,3,14) AND Nodes.ObjectSubType<>'ICMP' AND MINUTEDIFF(Nodes.LastSystemUpTimePollUtc,GETUTCDATE())>(Nodes.StatCollection*6)

14deansully

Thanks all. I've got it working, really handy report.