Cluster Reporting through VB Scripting
desmond....@googlemail.com
I need to develop a script or HTA which when I run
it will tell me if a Microsoft Cluster Group has failed over to
another Owner
other than its preferred owner. Currently I am using a very primitive
script connects to the MSCluster_NodeToActiveGroup and reports which
Groups are Active on a node which it gets from a text file containing
a list of Clusters. I pipe this out to an excel file. I run it at the
beginning when I know that all the Cluster Groups are running on
their
Preferred Node to create a baseline file called Cluster Master.xls. I
then run this daily and pipe to another excel file. I then copy the
info from this file into the next column in Cluster Master and
compare
the difference between A and B using =Countif(A:A,B1)>0
I then filter this and look for any false values which would indicate
that the result differs from the baseline thus something has failed
over. As you can imagine
this is far from perfect. and requires everyone in my team to have
the
macro
saved to their personal workbook etc. We cant seemt to get a script
which will simply compare the first preferred Node on a Cluster Group
to where it is actually running. If these dont match then obviously
it
has failed over and this should be reported via the script.
Can anyone help?