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

Group members


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
      and ContainerMemberSnapshots.EntityType='Orion.Nodes'
where ContainerMemberSnapshots.EntityID is NULL

I got it from here: 

0 Kudos