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

Group members

hello,

is there any way to make a report in which i could see which nodes does not belong to any group?

Find more posts tagged with

Accepted answers

All comments

This SQL query worked for me:

select Caption,IP_Address 
from nodesdata left outer join
     ContainerMemberSnapshots on 
          nodesdata.NodeID=ContainerMemberSnapshots.EntityID
      and ContainerMemberSnapshots.EntityType='Orion.Nodes'
where ContainerMemberSnapshots.EntityID is NULL

I got it from here: https://thwack.solarwinds.com/t5/NPM-Discussions/How-to-see-witch-nodes-are-not-assigned-in-a-group/m-p/127203

Quick Links