Which Windows Server is the Clustered Instance is Running On

When troubleshooting from SSMS, I need to know which Windows server my clustered instance is running on.   Surprised that this query is not already on the first page of the search engines.

select NodeName as 'Active Windows Server for Clustered Instance'
from sys.dm_os_cluster_nodes where is_current_owner = 1;

Leave a Comment