InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:20:35 GMT20http://www.sqlservercentral.com/Forums/Topic698101-471-1.aspxIs there a way to tell if the nodes are actually up and available?Mon, 03 Sep 2012 09:15:57 GMTUnicornsRrealhttp://www.sqlservercentral.com/Forums/Topic698101-471-1.aspxgreat script. can certainly use this as a supplement to cluster monitoring that i have in place at my company. in case we miss an alert for a failover, we can use this to find the active node and check it against what the active node should be.Excellent work.Regards,SteveSat, 09 May 2009 22:01:47 GMTS. Kusenhttp://www.sqlservercentral.com/Forums/Topic698101-471-1.aspxGood point. I didn't include that information as I assumed you should already know what clusters you have. But still a great addition to the code.RudyFri, 08 May 2009 11:16:34 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic698101-471-1.aspxThanks for pointing out the 2 DMV's!! If someone wanted to run this script automatically across all servers in their environment to find the clustered servers and collect information about them, I'd include ServerProperty('IsClustered') and ServerProperty('MachineName').Fri, 08 May 2009 10:44:23 GMTRobert Davishttp://www.sqlservercentral.com/Forums/Topic698101-471-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/cluster/66612/">Cluster Information</A>[/B]Wed, 15 Apr 2009 20:38:01 GMTRudy Panigas