We had a Risk and Health Assessment Program (RAP) for SQL Server running in our environment in the last few days and one of the issues in the final report was:
My PowerShell “wheels” started to roll and I suggested our team have a script to check for such inconsistences. So, here’s how we can perform a quick check against a two node cluster (or any other pair of computers) using PowerShell and find if the installed hotfixes are not identical.
First we use the Get-HotFix cmdlet to retrieve the list of hot-fix installed on each cluster node and then we use the Compare-Object cmdlet to compare the collections based on the HotFixID property. No result means the two nodes have the same set of hot-fixes installed and no action needs to be performed.
The output shows just one hotfix. We can see that the SideIndicator value (‘=>’) shows that the KB967752 hotfix is installed on ClusterNode2 (DifferenceObject) and that it is missing from ClusterNode1.