Optimize-WSUS

1.0

Optimize WSUS and its DB using official Microsoft SQL script and performs server maintenance.

  Prerequisites for running Invoke-Sqlcmd

  1. Save T-SQL script as WsusDBMaintenance.sql from: https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/reindex-the-wsus-database

  2. Navigate to: https://www.microsoft.com/en-US/download/details.aspx?id=55992 and install SQLSysClrTypes.msi

  3. Run from PowerShell
      - Register-PackageSource -provider NuGet -name nugetRepository -location https://www.nuget.org/api/v2
      - Install-Package Microsoft.SqlServer.SqlManagementObjects

  4. Run from PowerShell: Install-Module -Name SqlServer

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name Optimize-WSUS

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More