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
Store

Finding nodes with no group

I'm having trouble finding a way to sort nodes by a "no group" variable. Is this a thing?

Looking to clean up our grouping and find out which nodes do not have a group to belong to.

Find more posts tagged with

Accepted answers

All comments

This SQL query should work.

select NodeID, Caption from Nodes
where

not Caption in (

SELECT distinct FullName

FROM ContainerMemberSnapshots

where EntityDisplayName = 'Node'

)

Quick Links