Custom Properties on All Nodes

What this query does

Export all node custom property values for inventory reporting

SWQL Query

SELECT n.NodeName, n.IPAddress, n.Vendor, n.Location,
       cp.City, cp.Country, cp.SiteCode, cp.Environment, cp.Owner
FROM Orion.Nodes n
JOIN Orion.NodesCustomProperties cp ON n.NodeID = cp.NodeID
ORDER BY n.NodeName

custom properties

inventory

reporting

CMDB

Unlock the full POLARISNOC hub

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