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

Help with Interface capacity reports

Hello

I need list of interfaces that reach a capacity of over 65%

I just like to see those interfaces named only ones in that report?

I can not get that to work ..

Tia

Sja

Find more posts tagged with

capacity_management

Accepted answers

All comments

Hey sja,

This query gives you interfaces that are at 65% or greater based on input/output numbers.

SELECT

n.Caption AS NodeName, i.Caption AS Interface_Caption, i.Outbps AS Xmit_bps, i.Inbps AS Recv_bps, i.OutPercentUtil AS Xmit_Percent_Utilization,

i.InPercentUtil AS Recv_Percent_Utilization, (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 AS AvgXmitRecvPercentUtil

FROM

Nodes n INNER JOIN interfaces i ON (n.NodeID = i.NodeID)

Where (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 >= '65'

Should work on NPM 12.0 and over.

Quick Links