Generate a Report for installed Hotfix-Update-ServicePack for Bulk Servers

1. Generate a Report for installed Hotfix-Update-ServicePack for Bulk Servers.

2. Check a specific Hotfix is installed or not in Multiple Computers.

3. Get the latest Patching Date for bulk Computers.

_________________________________________________________________________________________________

1. Generate a Report for installed Hotfix-Update-ServicePack for Bulk Servers.

Please send me a mail at <bshwjt@gmail.com> . If you are getting any issue with this Script.

HotfixReport.zip - You will get two files in "HotfixReport.zip". See the help file for additonal information.

Generate a Report for installed Hotfix for Bulk Servers. You need to create a computers.txt & put the servers list into that text file. You can generate a report in a txt/csv or HTML file.Report is included "When installed", "who installed" & "Hotfix names" and "description". This should be expedite our task. You will get two text files.

You need to create a file called computers.txt & where you have to keep the computer name as below.

Run that Script. You will get a report(txt) for installed Hotfix for bulk Computers and get an additional output(txt) for unreachable computers.

OutPut is given below-You will get this report in your Desktop.

Provide the Rating If you find this is Helpful.

2. Check a specific Hotfix is installed or not in Multiple Computers.

PowerShell

Edit|Remove

$computers = Get-Content "c:\scripts\dclist.txt"
$Patch = "KB3144756" 
foreach ($computer in $computers)   
{   
if (get-hotfix -id $Patch -ComputerName $computer -ErrorAction SilentlyContinue)   
{   
Add-content "KB3144756 is Present in $computer" -path "$env:USERPROFILE\Desktop\Hotfix-Present.log"  
} 
Else   
{   
Add-content "KB3144756 is not Present in $computer" -path "$env:USERPROFILE\Desktop\Missing-Hotfix.log"    
}  
}

$computers = Get-Content "c:\scripts\dclist.txt" 
$Patch = "KB3144756"  
foreach ($computer in $computers)    
{    
if (get-hotfix -id $Patch -ComputerName $computer -ErrorAction SilentlyContinue)    
{    
Add-content "KB3144756 is Present in $computer" -path "$env:USERPROFILE\Desktop\Hotfix-Present.log"   
}  
Else    
{    
Add-content "KB3144756 is not Present in $computer" -path "$env:USERPROFILE\Desktop\Missing-Hotfix.log"     
}   
}

3. Get the latest Patching Date

PowerShell

Edit|Remove

###------------------------------###    
### Author : Biswajit Biswas-----###      
###--MCC, MCSA, MCTS, CCNA, SME--###    
###Email<bshwjt@gmail.com>-------###    
###------------------------------###    
###/////////..........\\\\\\\\\\\###    
###///////////.....\\\\\\\\\\\\\\###
function Hotfixreport { 
$computers = Get-Content C:\computers.txt   
$ErrorActionPreference = 'Stop'   
ForEach ($computer in $computers) {  
 
  try  
    { 

Get-HotFix -cn $computer | Select-Object PSComputerName,HotFixID,InstalledOn,InstalledBy -last 3 | FT -AutoSize
  
    } 
 
catch  
 
    { 
Add-content $computer -path "$env:USERPROFILE\Desktop\Notreachable_Servers.txt"
    }  
} 
 
} 
Hotfixreport > "$env:USERPROFILE\Desktop\Hotfixreport.txt"

###------------------------------###     
### Author : Biswajit Biswas-----###       
###--MCC, MCSA, MCTS, CCNA, SME--###     
###Email<bshwjt@gmail.com>-------###     
###------------------------------###     
###/////////..........\\\\\\\\\\\###     
###///////////.....\\\\\\\\\\\\\\### 
function Hotfixreport {  
$computers = Get-Content C:\computers.txt    
$ErrorActionPreference = 'Stop'    
ForEach ($computer in $computers) {   
  
  try   
    {  
 
Get-HotFix -cn $computer | Select-Object PSComputerName,HotFixID,InstalledOn,InstalledBy -last 3 | FT -AutoSize 
   
    }  
  
catch   
  
    {  
Add-content $computer -path "$env:USERPROFILE\Desktop\Notreachable_Servers.txt" 
    }   
}  
  
}  
Hotfixreport > "$env:USERPROFILE\Desktop\Hotfixreport.txt"

There is a known bug in Get-hotfix that you may not get the desired output as expected. Also you can use the below Code.

PowerShell

Edit|Remove

#Single server
Get-CimInstance -Class win32_quickfixengineering | 
Where-Object InstalledOn -gt (Get-Date).AddDays(-30) | 
Select-Object PSComputerName,HotFixID,InstalledBy,InstalledOn | Sort-Object PSComputerName

#Multiple Servers
Invoke-Command -ComputerName (cat C:\Temp\Biswajit\Servers.txt)
{Get-CimInstance -Class win32_quickfixengineering | 
Where-Object InstalledOn -gt (Get-Date).AddDays(-30)} | 
Select-Object PSComputerName,HotFixID,InstalledBy,InstalledOn | Sort-Object PSComputerName

#Single server 
Get-CimInstance -Class win32_quickfixengineering |  
Where-Object InstalledOn -gt (Get-Date).AddDays(-30) |  
Select-Object PSComputerName,HotFixID,InstalledBy,InstalledOn | Sort-Object PSComputerName 
 
#Multiple Servers 
Invoke-Command -ComputerName (cat C:\Temp\Biswajit\Servers.txt) 
{Get-CimInstance -Class win32_quickfixengineering |  
Where-Object InstalledOn -gt (Get-Date).AddDays(-30)} |  
Select-Object PSComputerName,HotFixID,InstalledBy,InstalledOn | Sort-Object PSComputerName

Biswajit Biswas a.k.a bshwjt

Infrastructure Engineer – Active Directory, Microsoft PKI, ADFS

Windows PowerShell

MSDN Script Gallery | Microsoft Community Contributor

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.