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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.