Report: Devices in groups / Devices that are not in any group

I can not remember how I came to this; but I have a report to show me nodes that are not in a group.

select Caption, NodeID, Nodes.Location

from nodes

where

  not Caption in (

   SELECT distinct [FullName]

   FROM [ContainerMemberSnapshots]

   where [EntityDisplayName] = 'Node'

  )

I will see if I can come of with anything else. Grouping can be very useful, so knowing the inclusiveness of nodes in a group will make management easier - my issue or challenge for this report is having multiple groupings in some cases.

Awesome
Thanks dear, this report will help me so much

You got it! I'll post any updated versions here as well if I can figure it out.

Not to be a contrarian, but I solved my grouping issues with one simple realization - there's nothing inherently wrong with having a group with only one member .  I don't have a lot of groups with only one member (three in fact), but it sure made reporting based on groups a lot easier.