Hello,
Is there any way to generate a report of devices and the groups to which the devices belong?
And also the list of devices that are not in any group?
Hello,
Is there any way to generate a report of devices and the groups to which the devices belong?
And also the list of 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.
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 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.