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

How to Exclude unmanaged nodes being affected and calculated for available percentage.

Hi, I got some questions about, how we want to exclude the unmanaged nodes being calculated for availability percentage. Kindly need your help.

SELECT 100 * SUM (CASE WHEN Status = 1 THEN 1 ELSE 0 END) / COUNT(*) AS Available_Percentage
FROM Orion.Nodes n
WHERE n.CustomProperties.Region IN ('Central - Network', 'East Coast - Network', 'Southern - Network', 'Northern - Network')

Find more posts tagged with

Accepted answers

mesverrum

At the end of your query add

And unmanaged != 1

Seashore

Hi, based on your query you just add one row: "

AND N.UnManaged=FALSE"

SELECT 
    100 * SUM (CASE WHEN Status = 1 THEN 1 ELSE 0 END) / COUNT(nodeid) AS Available_Percentage
FROM Orion.Nodes n
WHERE 
    n.CustomProperties.Region IN ('Central - Network', 'East Coast - Network', 'Southern - Network', 'Northern - Network')
    AND N.UnManaged=FALSE

All comments