SAM Application Component Non-Up Status

What this query does

Find all SAM application components that are not in an Up state

SWQL Query

SELECT n.NodeName, a.Name AS ApplicationName,
       ac.Name AS ComponentName, ac.Status,
       ac.LastTimeUp, ac.ComponentType
FROM Orion.APM.Application a
JOIN Orion.Nodes n ON a.NodeID = n.NodeID
JOIN Orion.APM.Component ac ON a.ApplicationID = ac.ApplicationID
WHERE ac.Status != 1
ORDER BY n.NodeName, a.Name

SAM

applications

components

availability

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

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