How To List Availability Group Names, Database Names, IPs, Ports, DNS Names in SQL Server

If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, IPs, Ports, DNS Names, you can query the system dmvs instead of looking through ssms (SQL Server Management Studio).

You can find these informations in the following T-SQL:

Faruk Erdem
Author: Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *