declare @cmd varchar(2048)
if SERVERPROPERTY('IsHadrEnabled')=1
	set @cmd='
with rs as 
(
select convert(varchar(20),count(1))+'' ''+left(role_desc,3) [rep]
,sum(case when synchronization_health<>2 then 1 else 0 end) [syncnothealth]
from sys.dm_hadr_availability_replica_states
where is_local=1
group by left(role_desc,3)
)
select distinct
	SERVERPROPERTY(''IsHadrEnabled'') [HADR]
	,SERVERPROPERTY(''IsClustered'') [Cluster]
	,reverse(stuff(reverse((select r2.rep+''; '' as [data()] from rs r2 for xml path(''''))),1,2,'''')) [Status]
	,sum([syncnothealth]) [notsynced]
from rs r1
option (recompile)'
else 
	set @cmd='select SERVERPROPERTY(''IsHadrEnabled'') [HADR],  SERVERPROPERTY(''IsClustered'') [Cluster], NULL [Status],NULL [notsynced]'
exec (@cmd)