2 of 2 people found this helpful
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
not Caption in (
SELECT distinct [FullName]
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.
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.