search for existing multiple KB files on multiple servers

Question

I have a script that will read server names in from a text file and then search for a specific KB update filename which works fine.

But what if I want to have each server searched in the serverlist.txt file searched for multiple KB update files? How could I do that?

$CheckComputers = get-content c:\temp\Path\serverlist.txt
# Define Hotfix to check
$CheckHotFixKB = "KB1234567";
foreach($CheckComputer in $CheckComputers)
{
 $HotFixQuery = Get-HotFix -ComputerName $CheckComputer | Where-Object {$_.HotFixId -eq $CheckHotFixKB} | Select-Object -First 1;
 if($HotFixQuery -eq $null)
 {
  Write-Host "Hotfix $CheckHotFixKB is not installed on $CheckComputer";
 }
 else
 {
  Write-Host "Hotfix $CheckHotFixKB was installed on $CheckComputer on by " $($HotFixQuery.InstalledBy);
 }
}

score 1 · Answer 1 · answered Apr 22 '16 at 21:22

Perhaps one query is better for check multi hotfixes

$NeededHotFixes = @('KB2670838','KB2726535','KB2729094','KB2786081','KB2834140')
Write-Host "Verify prerequisites hotfixes for IE11."
$InstalledHotFixes = (Get-HotFix).HotFixId
$NeededHotFixes | foreach {
  if ($InstalledHotFixes -contains $_) {
     Write-Host -fore Green "Hotfix $_ installed";
   } else {
     Write-Host -fore Red "Hotfix $_ missing";
  }
}

enjoy ;-)

Paul Savage · Accepted Answer · 2015-03-18T20:44:22.927

0

You'll need to set your KB's in an array:

$CheckHotFixKB = @(
"KB1234567"
"KB5555555"
"KB6666666"
"KB7777777"
)

And then do a nested foreach:

foreach($CheckComputer in $CheckComputers)
{
 foreach ($hotfix in $CheckHotFixKB) {
 $HotFixQuery = Get-HotFix -ComputerName $CheckComputer | Where-Object {$_.HotFixId -eq $hotfix} | Select-Object -First 1;
 if($HotFixQuery -eq $null)
 {
  Write-Host "Hotfix $hotfix is not installed on $CheckComputer";
 }
 else
 {
  Write-Host "Hotfix $hotfix was installed on $CheckComputer on by " $($HotFixQuery.InstalledBy);
 } }
}

edited Mar 18 '15 at 20:44

answered Mar 18 '15 at 18:57

Paul Savage

135
1
1
8

no problem, please click the checkbox for "answered", if you don't mind :) – Paul Savage Mar 18 '15 at 20:16
One thing is the output will list all the KB files in each line against each server so if one KB file is missing it does not identify which one. – MickH Mar 18 '15 at 20:39
Forgot to update the variables in the if/else statements, should be good now. – Paul Savage Mar 18 '15 at 20:45
Very good, looking clean now, and should be set to "answered" now, thanks again. – MickH Mar 19 '15 at 13:19

search for existing multiple KB files on multiple servers

2 Answers2