PowerShell Tip: Get-HotFix not working

2024-01-17

Summary

This TechNet wiki is based on the experience in my Client Environment. We use to execute a Hot Fix report after Patch Update. It's good to do this using scripts rather than manual intervention. Indeed, I was doing it using PowerShell.

Scenario

We have a SharePoint 2010 Farm running on Windows 2008 R2 Standard. 3 Servers in the farm as we all know One Web Front End One Application One SQL After the patch update My WFE and SQL responded for Get-HotFix Command but application server returned blank

Help

help Get-HotFix -Detailed

help Get-HotFix -Examples

help Get-HotFix -Full

PowerShell Code

# -----------------------------------------------------------------------------
# Script : SharePoint Farm Daily Reports
# Author : Chendrayan Venkatesan
# Puspose : To get Hot Fix inventory report for auditing
# -----------------------------------------------------------------------------

#Get All the Servers
$Servers = @("server1" , "server2")

#Get the hot-fix in a variable for desired output
$HotFixDetails = Get-HotFix -ComputerName $servers |
Select CSName , HotFixID , InstalledOn , InstalledBy , Caption , Description | ConvertTo-Html -Fragment
ConvertTo-Html -Body "$HotFixDetails" -CssUri C:\style.CSS | Out-File "Location to Save"

#Send Mail
$SMTP = "Your SMTP Server Name"
$From = "From Adddress"
$To = "To Adddress"

Send-MailMessage -SmtpServer $SMTP -From $From -To $To -Subject "SharePoint Hot Fix Installation Report" -Attachments "Location of the file"

Download Code

Script Center

Root Cause

Why one of the Windows 2008 R2 not responded to Get-HotFix? My CSV file has gave output like 'SPAPP-?!' Nothing I could have think of when I saw exception pop up in my server

Solution

System Update Readiness Tool for Windows 7 for x64-based Systems (KB947821) [May 2014]

Download and Fix the exception. Later executed the above script. Bingo!!! Turned Green.

Enjoy PowerShell :)

Share via