[SQL Server] Afficher les informations pour les bases configurées en Always-ON
SELECT T1.dns_name,
T1.port,
CONCAT(T1.dns_name ,',', T1.port)AS VNN,
T1.ip_configuration_string_from_cluster,
T2.name,
T3.replica_server_name,
T4.role_desc,
T5.database_name,
T3.availability_mode_desc,
T3.failover_mode_desc,
T3.secondary_role_allow_connections_desc,
T4.synchronization_health_desc,
T5.is_database_joined,
T5.is_failover_ready,
T5.is_pending_secondary_suspend,
T3.endpoint_url
FROMsys.availability_group_listeners T1
JOIN master.sys.availability_groups T2 ON T1.group_id = T2.group_id
JOIN sys.availability_replicas T3 ON T1.group_id = T3.group_id
JOIN sys.dm_hadr_availability_replica_states T4 ON T3.replica_id = T4.replica_id
LEFT JOIN sys.dm_hadr_database_replica_cluster_states T5 ON T4.replica_id = T5.replica_id
ORDER BY T5.database_name ASC, T4.role_desc ASC