Identify interfaces with excessive errors or discards indicating hardware or congestion issues
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 DESCAI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.