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

Report for failing SNMP/ WMI polling

I have already tried to use the LastSystemUpTimePollUtc but, i got a false result. An example a node with NULL value, upon testing, the WMI credential was successful and able to gather data. I tried to run the Poll Now as well as the Discover Now but the LastSystemUpTimePollUtc of the said node was still empty.

Would like to ask, do you guys any other technique with regard on this failing snmp/ wmi polling report?

Thank you.

Find more posts tagged with

Accepted answers

All comments

amarnath_r

Hello Manilyn,

Create a new SQL Report

For SNMP

SELECT n.Caption,

n.IP_Address,

DATEDIFF(mi,MAX(c.DateTime),GETDATE()) minutes_since

FROM Nodes n

INNER JOIN CPULoad c ON n.NodeID = c.NodeID

WHERE n.Status = 1 AND n.ObjectSubType LIKE 'SNMP'

GROUP BY n.Caption, n.IP_Address

HAVING DATEDIFF(mi,MAX(c.DateTime),GETDATE()) > 15

ORDER BY minutes_since DESC

For WMI

SELECT n.Caption,

n.IP_Address,

DATEDIFF(mi,MAX(c.DateTime),GETDATE()) minutes_since

FROM Nodes n

INNER JOIN CPULoad c ON n.NodeID = c.NodeID

WHERE n.Status = 1 AND n.ObjectSubType LIKE 'WMI'

GROUP BY n.Caption, n.IP_Address

HAVING DATEDIFF(mi,MAX(c.DateTime),GETDATE()) > 15

ORDER BY minutes_since DESC

sans

First off, I want to thank you for this.

I have a few WMI servers that are showing up, but for the life of me, I can't for the life of me figure out what the issue is or why isn't showing. Any ideas on where I should look?