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

SWQL/SQL to generate nodes down report excluding nodes that are "muted"

Hi - looking for help to generate a report showing nodes that are currently down but excluding nodes that have been muted. I think it is easier to exclude nodes that are unmanaged but couldn't figure how to exclude muted nodes. Thanks in advance.

Find more posts tagged with

mutednodes

nodesdownreport

Accepted answers

All comments

jellobones

You can just add all the other fields you need in your report but you could start with something like this

SELECT n.Caption
FROM Orion.Nodes n
WHERE n.Status = 2 AND n.NodeID NOT IN (SELECT ID FROM Orion.AlertSuppression)