Nodes Missing Required Custom Properties

What this query does

Find nodes that are missing key custom properties required for CMDB or alerting

SWQL Query

SELECT n.NodeName, n.IPAddress, n.Vendor,
       cp.Environment, cp.Owner, cp.SiteCode
FROM Orion.Nodes n
JOIN Orion.NodesCustomProperties cp ON n.NodeID = cp.NodeID
WHERE cp.Environment IS NULL
   OR cp.Owner IS NULL
   OR cp.SiteCode IS NULL
ORDER BY n.NodeName

custom properties

data quality

CMDB

audit

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

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