Get Basic Cluster Information

cellPadding=0 width=876>

PRINT ' **** Cluster Information ****'

PRINT ' '

PRINT ' The following is information on the cluster you are connected'

PRINT ' '

PRINT '... Name of all nodes used and are part of this failover cluster'

SELECT NodeName As Cluster_Node_Name FROM sys.dm_os_cluster_nodes

PRINT ' '

PRINT '... Node which is the active '

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS Active_Node_Name

PRINT ' '

PRINT '... Drive letters that are part of the resourse group which contain the data and log files'

SELECT DriveName as Shared_Drive_Name FROM sys.dm_io_cluster_shared_drives