SWQL Library
Interfaces
Complex JOIN
POLARISNOC Certified

Interface Error and Discard Rate

What this query does

Identify interfaces with excessive errors or discards indicating hardware or congestion issues

SWQL Query
SELECT n.NodeName, i.InterfaceName, i.InErrors, i.OutErrors,
       i.InDiscards, i.OutDiscards, i.InBandwidth
FROM Orion.NPM.Interfaces i
JOIN Orion.Nodes n ON i.NodeID = n.NodeID
WHERE i.InErrors > 0 OR i.OutErrors > 0 OR i.InDiscards > 0 OR i.OutDiscards > 0
ORDER BY i.InErrors DESC
errors
discards
interfaces
troubleshooting
Source:POLARISNOCยท POLARISNOC Original

Unlock the full POLARISNOC hub

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

Sign Up Free