Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Clustering > WMI to Determine Active Node in the Cluster using SQL Server Openq

Reply
Thread Tools Display Modes

WMI to Determine Active Node in the Cluster using SQL Server Openq

 
 
John Couch
Guest
Posts: n/a

 
      01-29-2009
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determine cluster name from Node name over network Erik Eckhardt Scripting 0 03-26-2008 03:08 PM
Cluster node passive don't take resources in "active,active-passiv Joel E. Clustering 3 09-05-2007 06:50 AM
Re: Migrating from single node print server to active/active print cluster Alan Morris [MSFT] Clustering 0 10-12-2006 06:35 PM
2 Node cluster restored to a single node -localquorum server Darryl Paterson Clustering 1 04-26-2006 05:26 PM
Re: What is info is written to the Cluster Log on an active node versus a passive node? Gerald Aigenbauer Clustering 0 01-17-2006 02:41 PM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59