Categories
HOW TO Microsoft PowerShell Windows 10 Windows 7 Windows 8 / 8.1 Windows Server 2008 Windows Server 2012 Windows Vista Windows XP

HOW TO get a list of pending Windows Updates of a Server with No Internet access using PowerShell

To get a list of pending Windows Updates of a Server with No Internet access, follow these steps:

  1. Download wsusscn2.cab from another pc/server with Internet Access
  2. Copy the wsusscn2.cab file in the Server that has No Internet access
  3. Open Windows PowerShell ISE as Administrator
  4. Run following PowerShell script assigning to the variable $Wsusscn2FilePath the correct path where you saved the wsusscn2.cab file
$Wsusscn2FilePath = "c:\tempwsusscn2.cab"

$UpdateSession = New-Object -ComObject Microsoft.Update.Session  
$UpdateServiceManager  = New-Object -ComObject Microsoft.Update.ServiceManager  
$UpdateService = $UpdateServiceManager.AddScanPackageService("Offline Sync Service", $Wsusscn2FilePath, 1)  
$UpdateSearcher = $UpdateSession.CreateUpdateSearcher()   
  
Write-Output "Searching for updates... `r`n"  
  
$UpdateSearcher.ServerSelection = 3 
 
$UpdateSearcher.IncludePotentiallySupersededUpdates = $true 
  
$UpdateSearcher.ServiceID = $UpdateService.ServiceID.ToString()  
  
$SearchResult = $UpdateSearcher.Search("IsInstalled=0") 
  
$Updates = $SearchResult.Updates  
  
if($Updates.Count -eq 0){  
    Write-Output "There are no applicable updates."  
    return $null  
}  
  
Write-Output "List of applicable items on the machine when using wssuscan.cab: `r`n"  
  
$i = 0  
foreach($Update in $Updates){   
    Write-Output "$($i)> $($Update.Title)"  
    $i++  
}

The script will return the list of pending updates or the message “There are no applicable updates”.

You will need to download manually the updates from another pc/server with Internet access, copy and install them manually as described in my previous post:

The steps have been tested in Windows Server 2016.

Sources:
Using WUA to Scan for Updates Offline
Using WUA to Scan for Updates Offline with PowerShell

Did my HOW TO help you? Leave a reply.

Categories
HOW TO Microsoft SQL Server Windows 10 Windows 7 Windows 8 / 8.1 Windows Server 2008 Windows Server 2012 Windows Vista Windows XP

HOW TO download SQL Server Service Packs or Windows Updates Offline Installers

Microsoft Update Catalog contains the list of Windows Updates and also the Updates of Microsoft Products that can be installed via Windows Update functionality.

Using the Search bar it is possible to filter the results to search, for example writing “SQL” you will find a list of Service Packs, Updates, Future Packs and Critical Updates for different versions of SQL Server.

Steps to download and install updates from the Windows Update Catalog

To download updates from the Windows Update Catalog, follow these steps:

  1. Click Download.
    Note If you are prompted, click Accept to accept the license agreement.
  2. Select the location where you want to save the updates. You can either type the full path of the folder, or you can click Browse to locate the folder.
  3. Click Continue to start the download.
  4. When the download is complete, click Close to close the Download Window.
  5. Close the Windows Update Catalog Window.
  6. Find the location that you specified in step 2.
  7. Double-click each update, and then follow the instructions to install the update. If the updates are intended for another computer, copy the updates to that computer, and then double-click the updates to install them.

Source: How to download updates that include drivers and hotfixes from the Windows Update Catalog

Did my HOW TO help you? Leave a reply.