sys.dm_os_cluster_nodes
This view returns a row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance has been defined.
sys.dm_io_cluster_shared_drives
This view returns the drive name of each of the shared drives if the current server instance is a clustered server. If the current server instance is not a clustered instance it returns an empty rowset.
Permission
You must have VIEW SERVER STATE permission for the SQL Server instance.
SELECT *
FROM sys.dm_os_cluster_nodes
–OR
SELECT *
FROM Fn_virtualservernodes()
–Shared Drives
SELECT *
FROM sys.dm_io_cluster_shared_drives
