How to Get WSFC Name Using T-SQL I know how to get the name of the current node, but is there a simple T-SQL query to use to get the Windows Server Failover Cluster name that the clustered instance is part of?

The SQL Server version is 2014 and the OS is Windows Server 2012
@Molenpad, you shall get the WSFC details through below mention TSQL query.

select * from master.sys.dm_hadr_cluster;
Go


Here cluster_name is the Name of the WSFC cluster that hosts the instances of SQL Server that are enabled for Always On availability groups.

I am also attaching the screen shot.


Note: I have highlighted the WSFC name due to my Prod server.

for your ref Here