This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How to confirm that any device has not joined the group

Hi Everyone,

Goodday~

Because the monitoring quantity is more than 2000 device.

When doing group classification,is there any way to find devices that have not yet been grouped into groups?

  • If you want a list of the nodes that are not a member of any group, this is a simple query that can be used in a Custom Query resource, or in a report with a Custom SWQL data source.

    SELECT Nodes.NodeID, Nodes.Caption, Nodes.IP_Address
    FROM Orion.Nodes
    LEFT JOIN Orion.ContainerMembers ON ContainerMembers.MemberPrimaryID=Nodes.NodeID AND MemberEntityType='Orion.Nodes'
    WHERE ContainerMembers.ContainerID IS NULL