There is already a report prebuilt for group availability. You can copy that and change the time.
BUT, if you need the SWQL here is an example:
C.Name AS [GroupName],
AVG(CS.PercentAvailability) AS [Availability]
FROM Orion.ContainerStatus CS
INNER JOIN Orion.Container C ON CS.ContainerID=C.ContainerID
GROUP BY C.Name
its showing all group = 100 % , which is wrong
Group = ATM Branch
availability = Yesterday
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.