@GitHub Copilot - Welcome @BanterBoy, I’m your Copilot and I’m here to help you get things done faster. I can identify issues, explain and even improve code.

You can ask generic questions, but what I’m really good at is helping you with your code. For example:

Generate unit tests for my code Explain the selected code Propose a fix for the bugs in my code If you want to learn more about my capabilities and limitations, check out the Copilot documentation.

I’m powered by AI, so surprises and mistakes are possible. Make sure to verify any generated code or suggestions, and share feedback so that we can learn and improve.

@BanterBoy: - Explain what the script does and why it is useful.

@GitHub Copilot -



 NAME: Get-HotFixReport.ps1

 AUTHOR: Jan Egil Ring
 EMAIL: [email protected]

 COMMENT: Script to generate an installation-report for specified hotfixes on a set of computers retrieved from Active Directory.

          The script leverages Microsoft`s PowerShell-module for Active Directory to retrieve computers.
          Before running the script, customize the three variables under #Custom variables

          More information:

 You have a royalty-free right to use, modify, reproduce, and
 distribute this script file in any way you find useful, provided that
 you agree that the creator, owner above has no warranty, obligations,
 or liability for such use.

 1.0 31.10.2010 - Initial release


#requires -version 2

#Import Active Directory module
Import-Module ActiveDirectory

# Get the script path
$ScriptPath = { Split-Path $MyInvocation.ScriptName }

#Custom variables
#$Computers = Get-ADComputer -Filter * -Properties Name,Operatingsystem | Where-Object {$_.Operatingsystem -like "*server*"} | Select-Object Name
$Computers = @()
$HotFix = "KB979744,KB979744,KB983440,KB979099,KB982867,KB977020"
$CsvFilePath = $(&$ScriptPath) + "\Hotfixes.csv"

# Get Computer Name
$ComputerName = (get-content env:COMPUTERNAME)

$Computers += $ComputerName

#Variable for writing progress information
$TotalComputers = ($computers | Measure-Object).Count
$CurrentComputer = 1

#Create array to hold hotfix information
$Export = @()

#Splits the array if more than one hotfix are provided
$Hotfixes = $HotFix.Split(",")

#Loop through every computers
foreach ($computer in $computers) {

    #Loop through every hotfix
    foreach ($hotfix in $hotfixes) {
        #Write progress information
        Write-Progress -Activity "Checking for hotfix $hotfix..." -Status "Current computer: $computer" -Id 1 -PercentComplete (($CurrentComputer / $TotalComputers) * 100)

        #Create a custom object for each hotfix
        $obj = New-Object -TypeName psobject
        $obj | Add-Member -Name Hotfix -Value $hotfix -MemberType NoteProperty
        $obj | Add-Member -Name Computer -Value $computer -MemberType NoteProperty

        #Check if hotfix are installed
        try {
            if (Test-Connection -Count 1 -ComputerName $computer -Quiet) {
                Get-HotFix -Id $hotfix -ComputerName $computer -ea stop | Out-Null
                $obj | Add-Member -Name HotfixInstalled -Value $true -MemberType NoteProperty
                $obj | Add-Member -Name ErrorEncountered -Value "None" -MemberType NoteProperty
            else {
                $obj | Add-Member -Name HotfixInstalled -Value $false -MemberType NoteProperty
                $obj | Add-Member -Name ErrorEncountered -Value $error[0].Exception.Message -MemberType NoteProperty

        catch {
            $obj | Add-Member -Name HotfixInstalled -Value $false -MemberType NoteProperty
            $obj | Add-Member -Name ErrorEncountered -Value $error[0].Exception.Message -MemberType NoteProperty

        #Add the custom object to the array to be exported
        $Export += $obj


    #Increase counter variable
    $CurrentComputer ++


#Export the array with hotfix-information to the user-specified path
$Export | Export-Csv -Path $CsvFilePath -NoTypeInformation

Back to Top


Please feel free to copy parts of the script or if you would like to download the entire script, simple click the download button. You can download the complete repository in a zip file by clicking the Download link in the menu bar on the left hand side of the page.

Report Issues

You can report an issue or contribute to this site on GitHub. Simply click the button below and add any relevant notes. I will attempt to respond to all issues as soon as possible.


Back to Top