Identify the top 10 busiest interfaces for performance trending
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 DESCAI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.