PowerShell Script to Retrieve Last Patch Status for Windows Servers

PowerShell Script to Retrieve Last Patch Status for Windows Servers

# Get list of servers from text file
$servers = Get-Content C:\serverlist.txt

# Initialize empty array to store patch status information
$patchStatus = @()

# Loop through each server and get last patch date
foreach ($server in $servers) {
    $os = Get-WmiObject -Class Win32_OperatingSystem -ComputerName $server
    $lastPatch = $os.ConvertToDateTime($os.LastPatch)
    $patchStatus += New-Object PSObject -Property @{
        ServerName = $server
        LastPatchDate = $lastPatch
    }
}

# Output patch status information to CSV file
$patchStatus | Export-Csv C:\patchstatus.csv -NoTypeInformation
  

This script assumes that the text file containing the list of servers is located at "C:\serverlist.txt" and that the CSV file containing the patch status information will be saved at "C:\patchstatus.csv". You can change the path of the files as per your requirements. Also, you may need to run the script as an administrator and with appropriate permissions to be able to connect to the remote servers and retrieve the patch status information.