SAM Application Component Status Overview

What this query does

Get all application components with their current status and responsible node

SWQL Query

SELECT n.NodeName, a.Name AS ApplicationName, ac.Name AS ComponentName,
       ac.Status, ac.LastTimeUp, ac.ComponentType, a.ApplicationAlert
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

status

Unlock the full POLARISNOC hub

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