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

List Nodes without any resources selected to monitor

I've had users add nodes to solarwinds without selecting any resources to monitor. I'd like to have a report lists nodes that are not monitoring any metrics (volumes, cpu, memory) with polling method != 'ICMP'.

I can visually identify nodes that have resources selected by looking at Manage Nodes and looking for an arrow to the left of node. If the node has an arrow, it has resources selected, if it is missing then no resources have been selected.

The screenshot shows that the top node has resources and the bottom does not.

Is there a query I can run to pull this list?

Find more posts tagged with

Accepted answers

raymondakrawi

Try this sql query for devices that are not polling any interfaces. This works if you poll via SNMP or WMI.

SELECT
top 10
Nodes.Caption, Nodes.NodeID

FROM Nodes
where (nodes.ObjectSubType = 'snmp' or nodes.ObjectSubType ='wmi')
and
(
nodes.nodeid not in
(select nodeid from Interfacesgroup by nodeid
)

)

Or try this for devices that are not polling for volumes (you will need to add your custom properties in the where clause to exclude network gear and other items that don't have volumes)

SELECT top 10 Nodes.Caption, Nodes.NodeID FROM Nodes

where (nodes.ObjectSubType = 'snmp' or nodes.ObjectSubType ='wmi')and nodes.Type <> 'RIBLoE_iLo'and(nodes.nodeid not in

(select nodeid from volumes  group by nodeid )

)

All comments

donrobert5

Create a custom report based on Polling Method.

https://thwack.solarwinds.com/discussion/104900/how-to-identify-whether-any-node-is-polling-with-snmp-or-icmp-and-how-to-get-the-list-of-devices-which-are-snmp-connection-lost-only

swright

I'm looking for a process to report when a node has been added, but no metrics are being monitored. The node is added with a polling method other than ICMP, but List Resources was not ran to choose monitoring a fixed disk, physical memory, nic, etc.

naveensingh43

try the below

SELECT
N.NodeID,
N.Caption AS NodeName,
N.IPAddress,
N.Vendor,
N.MachineType,
N.ObjectSubType,
N.Status,
N.AgentVersion,
N.LastSync
FROM Orion.Nodes N
WHERE N.UnManaged = FALSE

AND NOT EXISTS (
SELECT 1
FROM Orion.NPM.Interfaces I
WHERE I.NodeID = N.NodeID
)

AND NOT EXISTS (
SELECT 1
FROM Orion.Volumes V
WHERE V.NodeID = N.NodeID
)

AND NOT EXISTS (
SELECT 1
FROM Orion.APM.Application A
WHERE A.NodeID = N.NodeID
)

AND NOT EXISTS (
SELECT 1
FROM Orion.HardwareHealth.HardwareInfo H
WHERE H.NodeID = N.NodeID
)

AND NOT EXISTS (
SELECT 1
FROM Orion.Pollers P
WHERE P.NetObject = 'N:' + ToString(N.NodeID)
)

ORDER BY N.Caption

swright

When I run the query, I get an error: "no viable alternative at input 'EXISTS' in Where clause"

naveensingh43

thanks for replying let me try to fix it

JaroslawLadyga

Does the function EXISTS exists in SQWL?

naveensingh43

No SQWL do not support EXISTS

raymondakrawi

Try this sql query for devices that are not polling any interfaces. This works if you poll via SNMP or WMI.

SELECT
top 10
Nodes.Caption, Nodes.NodeID

FROM Nodes
where (nodes.ObjectSubType = 'snmp' or nodes.ObjectSubType ='wmi')
and
(
nodes.nodeid not in
(select nodeid from Interfacesgroup by nodeid
)

)

Or try this for devices that are not polling for volumes (you will need to add your custom properties in the where clause to exclude network gear and other items that don't have volumes)

SELECT top 10 Nodes.Caption, Nodes.NodeID FROM Nodes

where (nodes.ObjectSubType = 'snmp' or nodes.ObjectSubType ='wmi')and nodes.Type <> 'RIBLoE_iLo'and(nodes.nodeid not in

(select nodeid from volumes  group by nodeid )

)

swright

This is exactly what I am looking to do! Thank you, this works perfectly!