Down Interfaces by Node

What this query does

List all administratively or operationally down interfaces grouped by node

SWQL Query

SELECT n.NodeName, i.InterfaceName, i.AdminStatus, i.OperStatus,
       i.InterfaceType, i.IPAddress
FROM Orion.NPM.Interfaces i
JOIN Orion.Nodes n ON i.NodeID = n.NodeID
WHERE i.OperStatus = 2
ORDER BY n.NodeName, i.InterfaceName

interfaces

down

availability

Source:OrionSDK GitHub· SolarWinds Orion SDK GitHubView original

Unlock the full POLARISNOC hub

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