SELECT SERVERPROPERTY('IsClustered'), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'), SERVERPROPERTY('MachineName')

declare @Nodes table ( NodeNum sysname, name sysname null )
insert into @Nodes( NodeNum )
EXEC master..xp_regenumkeys 'HKEY_LOCAL_MACHINE','CLUSTER\Nodes\'

declare @NodeNum sysname, @NodeName sysname
declare c cursor local fast_forward
for select NodeNum
    from @Nodes
    
open c
fetch next from c into @NodeNum
while @@fetch_status =  0 
begin
  set @NodeName = 'CLUSTER\Nodes\' + @NodeNum

  EXEC master..xp_regread N'HKEY_LOCAL_MACHINE',
                          @NodeName,
                          N'NodeName',
                         @NodeName OUTPUT

  update @Nodes set name = @NodeName
  where NodeNum = @NodeNum

  fetch next from c into @NodeNum
end

close c
deallocate c

select *
from @Nodes