Network Management

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

How to create a report that lists nodes that fail SNMP or WMI polling.

First published date

11/29/2018 11:00 PM

Last published date

2/25/2025 6:03 PM

Overview

This article describes the SQL syntax to create a report that lists nodes that fail SNMP or WMI polling.

Product section

Network Performance Monitor

Resolution

  1. From the SolarWinds Web Console, Go to Reports > All Reports. Click on Manage Reports.
  2. Click on create new Report.
  3. Select Custom Table
  4. Select method as "Advanced Database Query (SQL,SWQL)"  as the Selection Method
  5. Choose SQL as the query type
  6. Paste the query below and run preview.
  7. The following advanced SQL report checks the last 5 polls where snmp\wmi communication has been lost
-- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation.
SELECT Nodes.NodeID AS NetObject, Nodes.Caption AS Name
FROM Nodes 
Where LastSystemUpTimePollUtc < DATEADD( second, -5*PollInterval, GETUTCDATE()) AND status =1 AND ObjectSubType IN ('SNMP', 'WMI')
 
  •  The Preview option helps to see the results. Also the report can be saved for later use.
Create an advanced SQL report to check nodes that fail SNMP-WMI polling.PNG