SWQL Library
Groups
Complex JOIN
POLARISNOC Certified

Node Group Membership Report

What this query does

List all nodes and the Orion groups they belong to for topology reporting

SWQL Query
SELECT g.Name AS GroupName, n.NodeName, n.IPAddress,
       n.Status, n.Vendor, gm.GroupID
FROM Orion.Groups g
JOIN Orion.GroupMembers gm ON g.GroupID = gm.GroupID
JOIN Orion.Nodes n ON gm.MemberPrimEntityID = n.NodeID
ORDER BY g.Name, n.NodeName
groups
membership
inventory
topology
Source:POLARISNOCยท POLARISNOC Original

Unlock the full POLARISNOC hub

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

Sign Up Free