SWQL Library
Interfaces
Complex JOIN
POLARISNOC Certified

Top 10 Most Utilized Interfaces

What this query does

Identify the top 10 busiest interfaces for performance trending

SWQL Query
SELECT TOP 10 n.NodeName, i.InterfaceName,
       i.InBandwidth, i.OutBandwidth,
       i.InPercentUtil, i.OutPercentUtil,
       i.InterfaceSpeed
FROM Orion.NPM.Interfaces i
JOIN Orion.Nodes n ON i.NodeID = n.NodeID
WHERE i.OperStatus = 1
ORDER BY CASE WHEN i.InPercentUtil > i.OutPercentUtil
         THEN i.InPercentUtil ELSE i.OutPercentUtil END DESC
interfaces
top 10
bandwidth
performance
Source:POLARISNOCยท POLARISNOC Original

Unlock the full POLARISNOC hub

AI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.

Sign Up Free