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

“Nodes Without Monitoring” Health Report

A built-in report that automatically detects:
Nodes without disks monitored
Nodes without interfaces
Nodes without alerts
This helps ensure no blind spots.

Find more posts tagged with

Active

Status: Active

Comments

P.Bhattacharjee

@naveensingh43 Try creating reports with the below .

1) Nodes without disks (no fixed volumes monitored)

SELECT    n.NodeID,    n.Caption,    n.IPAddress,    n.Vendor,    n.ObjectSubType AS PollingMethodFROM Orion.Nodes nLEFT JOIN Orion.Volumes v    ON v.NodeID = n.NodeID       AND v.VolumeType = 'Fixed Disk'WHERE v.VolumeID IS NULL  AND (n.Vendor LIKE 'Windows%' OR n.Vendor LIKE 'Linux%')ORDER BY n.Caption

2) Nodes without interfaces monitored

SELECT    n.NodeID,    n.Caption,    n.IPAddress,    n.ObjectSubType AS PollingMethodFROM Orion.Nodes nLEFT JOIN Orion.NPM.Interfaces i    ON i.NodeID = n.NodeIDWHERE i.InterfaceID IS NULL  AND n.ObjectSubType <> 'ICMP'   -- exclude pure ICMP nodesORDER BY n.Caption

3) Nodes without alerts (no alert ever targets them)

There is no built-in report that reliably says “this node is not covered by any alert definition”; this depends on each alert’s scope logic, which is stored as XML/condition text in Orion.AlertConfigurations.

A partial approach is to look for nodes that have never had an alert status row:

SELECT    n.NodeID,    n.Caption,    n.IPAddress,    n.ObjectSubType AS PollingMethodFROM Orion.Nodes nLEFT JOIN Orion.AlertStatus s    ON s.ObjectType = 'Orion.Nodes'   AND s.ActiveObject = n.UriWHERE s.AlertObjectID IS NULLORDER BY n.Caption

This finds nodes that have never appeared in AlertStatus, i.e., nothing has ever actually fired for them. It does not guarantee that no alert could fire in the future, only that none has yet.

naveensingh43

thanks for sharing.