Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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?

Find more posts tagged with

Accepted answers

All comments

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

Quick Links