• I also ran the following command and it showed up the node which isnt taking the instance's name also in the result set:

    SELECT * FROM sys.dm_os_cluster_nodes