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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
@Molenpad, you shall get the WSFC details through below mention TSQL query.
select * from master.sys.dm_hadr_cluster; Go
cluster_name is the Name of the
WSFC cluster that hosts the instances of SQL Server that are enabled for Always On availability groups.
Note: I have highlighted the WSFC name due to my Prod server.
for your ref Here