Via Transact SQL with this query:
SELECT ag.[name] as & # 39; Name AG & # 39 ;, ag.Is_Distributed, ar.replica_server_name as & # 39; Replica Name & # 39; FROM sys.availability_groups ag, sys.availability_replicas ar WHERE ag.group_id = ar.group_id;
I can find the availability groups (distributed or not) visible from the SQL server.
If it is a member of AG I can see the instance. When it is DAG I can not see the instances …
From the primary, with a query, is there a way to get the main instance of the secondary AG in the DAG?
Or to get the name of the secondary AG listener.