I am attempting to determine which node in the cluster is the active one in
an active/passive setup. I am writing this to execute the query (hopefully)
from sql server. However, I cannot find any documentation explaining how to
determine this information. An example of what I am doing is below:
select *
from openquery(LinkedServer, 'set fmtonly off; exec master..xp_cmdshell
''wmic.exe partition /format:value''')
I would be replacing partition with the class I would need to get the
cluster information from. Thanks for any help in advance.
|