Content in Windows - WSUS

• Access WSUS with SQL Server Management Studio

  Open Microsoft SQL Server Management Studio by using right click, “Run as administrator” WID2008np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query WID2012+np:\\.\pipe\MICROSOFT##WID\tsql\query Source: https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/ 
  63 views
• Add non-clustered indexes to the WSUS database

  Add non-clustered indexes to the WSUS database   -- Create custom index in tbLocalizedPropertyForRevision USE [SUSDB] CREATE NONCLUSTERED INDEX [nclLocalizedPropertyID] ON [dbo].[tbLocalizedPropertyForRevision] (
  45 views
• Decline Superseded Updates PowerShell WSUS

  Decline-SupersededUpdates.ps1 e.g. Decline-SupersededUpdates.ps1 -UpdateServer SERVERNAME -Port 8531 -ExclusionPeriod 90  Copy the below code into a file called Decline-SupersededUpdates.ps1 <# .SYNOPSIS
  52 views
• Reindex the WSUS database

  This SQL Query does basic maintenance tasks on SUSDB: Identifies indexes that are fragmented, and defragments them. For certain tables, a
  71 views
• WSUS Cleanup Scripts

  Three Cleanup Scripts Cleanup-WSUSserver.ps1Decline-Superseded Updates With Exclusion Period via SMSSwsus-cleanup-updates-v4.ps1 Cleanup-WSUSserver.ps1 $server = 'localhost' $port = '8530' Write-Progress -Activity 'Getting WSUS server' $WSUSserver = Get-WsusServer -Name
  93 views
• WSUS Client-Side targeting by Group Policy

  Configure WSUS to utilize Group Policy or Registry settings for computer group assignment rather than using the Update Services Console.WSUS
  61 views
• WSUS Client-Side targeting by registry

  Configure WSUS to utilize Group Policy or Registry settings for computer group assignments rather than using the Update Services Console.WSUS
  62 views
• WSUS Migration - PSWSUSMigration

  Migrate WSUS by exporting the following value* Computers, Groups including Computer Membership* Approvals, Declines and Expired patchesConfiguration Options Install PSWSUSMigration moduleInstall-Command
  59 views

Windows