Hi All,

Often we used to login into nodes, to find active clustered node for Sql server instance.

Run below query in Sql server instance query window.

SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)

Its easy way to get the information.

Regards,

Chaitanya