for Group Target availability report. select TARGET_NAME,TARGET_TYPE,START_TIMESTAMP,AVAILABILITY_STATUS,AVAILABILITY_STATUS_CODE,TYPE_DISPLAY_NAME from mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%' and target_name in ( select MEMBER_TARGET_NAME from mgmt$target_flat_members where AGGREGATE_TARGET_GUID='2D063F91D5E72C284CA8F36604402DA7') select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where target_name in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members where AGGREGATE_TARGET_GUID='xxxxxxxxxx') group by TARGET_TYPE; select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%' and target_name in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members where AGGREGATE_TARGET_GUID='xxxxxxxxx') group by TARGET_TYPE; select TARGET_TYPE,AVAILABILITY_STATUS,count(TARGET_NAM...