Script to find Cluster Node Info

Cluster Node Info

SELECT @@servername as Server_Name ,
@@version as Version,
SERVERPROPERTY('productversion') as Version_Number,
SERVERPROPERTY ('productlevel') Service_Pack,
SERVERPROPERTY ('edition')as Edition,
serverproperty ('ComputerNamePhysicalNetbios') as currentnod