I've seen this around in other posts but not in a direct way or even with a solution, if there is any.
We use the availability report to get a weekly list of availability of our groups but it counts unmanaged as down, which doesn't make any sense in a report of this nature.
Is there any way to overcome this? I've tried Group Availability, Group Member Availability and it's all the same...
Has anyone out there produced any report like this that gives a real availability % of active nodes?
Wow. That seems like an oversight to me. I'd hit up Support to make sure that's not a bug and then if it isn't at least put in a feature request for it to change.
So it looks like there's two percent availabilities, one for the group itself and one for the group members. If you just need the group itself then it should be fine to just use PercentAvailability, otherwise you may need to do something custom for PercentMembersAvailability for your report.
My first thought is using a case statement and the Orion.ContainerMembers table (I'm doing this all through SWQL) to custom count it, there might be easier ways, but this is what came to mind first:
avg(case when status = 1 then 1 when status = 9 then 1 end) as [newavg]
FROM Orion.ContainerMembers cm
group by cm.Container.Name
I did not undertsand the query
I am also facing Similar challenges in My Environment.
I wish to report on Group member availability including Un managed Time.
i can see my report shows Group members availability 99.XX% but Individual Node shows 100% available.
I wish to report true availability based on Group as I have big environment ~1000 Network Devices.
Requesting you suggest meaning of 1 and 9 .in query
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.