-
Re: Report: Devices in groups / Devices that are not in any group
cahunt
Feb 16, 2016 9:43 AM
2 of 2 people found this helpfulI 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.
-
Re: Report: Devices in groups / Devices that are not in any group
Awesome
Thanks dear, this report will help me so much-
Re: Report: Devices in groups / Devices that are not in any group
cahunt
Feb 17, 2016 3:31 PM
You got it! I'll post any updated versions here as well if I can figure it out.
-
-
-
Re: Report: Devices in groups / Devices that are not in any group
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.