Clustered SQL server - Get the current node name of running instance

One way to get the current node name of running instance of clustered SQL server would be to execute the following scripts:

--Check SQL Server instance name SELECT @@SERVERNAME --Check the name of the node on which the clustered -- SQL Server instance is running on SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName]

Alternatively, you may run Server manager (right click on "Computer" in start menu and choose "Manage"), then
Features -> Failover Cluster Manager -> [The cluster name] -> Services and applications -> SQL server

It shows details and the "Current Owner" shows the node which SQL server is running on that node.

Clustered SQL server - Get the current node name of running instance