SELECT name, db_name(database_id),replica_server_name,endpoint_url,availability_mode_desc,failover_mode_desc,seeding_mode_desc,backup_priority,cluster_type_desc,required_synchronized_secondaries_to_commit,
is_local,is_distributed,is_primary_replica,synchronization_health_desc,synchronization_state_desc,recovery_lsn,last_hardened_lsn,last_hardened_time,secondary_lag_seconds
FROM sys.availability_replicas AS ar
INNER JOIN
sys.availability_groups AS ag
ON ar.group_id = ag.group_id
INNER JOIN
sys.dm_hadr_database_replica_states AS rs
ON ar.group_id = rs.group_id
AND ar.replica_id = rs.replica_id
ORDER BY name;