Re: Script to find out what node owns the resource

It can be done with associations. For instance, the
MSCluster_NodeToActiveResource association class associates a Cluster Node
with an Active Resource.

You could also write a simple vbscript similar to the one below should give
you the owner node. You would need to replace "YourClusterName" and
"YourGroupNameContaingResources" appropriately.

Dim objCluster
Set objCluster = CreateObject("MSCluster.Cluster")
objCluster.Open("YourClusterName")
WScript.Echo
objCluster.ResourceGroups.Item("YourGroupNameContaingResources").OwnerNode.­
Name
Set objCluster = Nothing

Regards,
John



<sergueim@xxxxxxxxxxx> wrote in message
news:1155308367.647071.75450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

If I use the CLUSTER.EXE command I can easily identify a node that owns
a resource.


Command: cluster ssholt2av101 res ssholt2av102

Outlut:

Listing status for resource 'ssholt2av102':

Resource Group Node Status
-------------------- -------------------- --------------- ------
ssholt2av102 SQL2-App SSHOLT2AU201 Online

=========
I'm wondering if there is a way to do the same with WMI?

Thanks in advance,

Serguei



.