--since Containers_AlertsAndReportsData is a view, run sp_helptext on Containers_AlertsAndReportsData, you can add more columns as needed--
SELECT
caar.GroupName AS Group_Name,
caar.GroupStatusDescription AS Group_Status,
caar.GroupPercentAvailability AS Group_Availability,
caar.GroupMemberName AS Group_Member_Name,
caar.GroupMemberStatusDescription AS Group_Member_Status,
caar.GroupMemberPercentAvailability AS Group_Member_Availability
FROM SolarWindsOrion.dbo.Containers_AlertsAndReportsData caar
Thanks.
Mahidhar Vattem