cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Group members

hello,

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

0 Kudos
1 Reply
Level 14

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/... 

0 Kudos