MS Cluster Resume Node

Usage and Config Server Automation
1

In the Sample Automation Plan for patching SQL Server Clusters, one of Tasks (ID 115) has relevance that excludes Windows Server 2016. It uses a Visual Basic script to resume the node after it has been made unavailable as a resource owner. The other tasks in this plan all use PowerShell scripts and apply to any OS after Win2008. The script includes the following:

strComputer = "."
Set clusterWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\mscluster")

Set colItems = clusterWMIService.ExecQuery("Select * from MSCluster_Node  where Name='"  & hostName & "'",,48)

	For Each objItem In colItems
		Set nodeToPause =  objItem
		nodeToPause.Resume()
	Next

Two questions:

  1. Is there any reason that the Visual Basic commands won’t work in 2016?

  2. Is there some reason IBM hasn’t updated this task to use PowerShell scripts?

Thanks

2 Likes
2

Bumping this question - are there plans to update this for Win Server 2016?

Thanks @Aram, @mcjee, @MDG, and @JasonWalker