Credits:
Author: Unknown
Date: 14 May 2009
Description
Retrieve the cluster active node, plus a list of nodes and shared drives available.
It is very basic information, but easier than grabbing time from the DBA if cluster manager is locked down (as it should be).
Code
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
|