sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)
Applies to: 
SQL Server
Returns a row for each Always On availability replica (regardless of its join state) of all Always On availability groups (regardless of replica location) in the Windows Server Failover Clustering (WSFC) cluster.
| Column name | Data type | Description |
|---|---|---|
| replica_id | uniqueidentifier | Unique identifier of the availability replica. |
| replica_server_name | nvarchar(256) | Name of the instance of SQL Server hosting the replica. |
| group_id | uniqueidentifier | Unique identifier of the availability group. |
| join_state | tinyint | 0 = Not joined 1 = Joined, standalone 2 = Joined, failover cluster instance |
| join_state_desc | nvarchar(60) | NOT_JOINED JOINED_STANDALONE JOINED_FAILOVER_CLUSTER_INSTANCE |
Permissions
Requires VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.