Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Create an advanced SQL report to check nodes that fail SNMP\WMI polling

Create an advanced SQL report to check nodes that fail SNMP\WMI polling

Table of contents
No headers

Updated March 11th, 2016

 

  1. Go to Report Writer (Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer)
  2. Select File Menu > New Report
  3. Choose "Advanced SQL"  as the report type
  4. The following advanced SQL report checks the last 5 polls where snmp\wmi communication has been destroyed
    • SELECT Nodes.NodeID AS NetObject, Nodes.Caption AS NameFROM NodesWhere LastSystemUpTimePollUtc <
    • DATEADD( second, -5*PollInterval, GETUTCDATE()) AND status =1 AND ObjectSubType IN ('SNMP', 'WMI')
  5.  The Preview option helps to see the results. Also the report can be saved for latter use.
Last modified

Tags

Classifications

Public