Windows / Windows - WSUS 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
...
Windows / Windows - WSUS 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 ...
Windows / Windows - WSUS 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 ...
Windows / Windows - WSUS 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 ...
SQL / SQL - Scripts 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 ...
SQL 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/
...
Windows / Windows - WSUS 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 ...
Windows / Windows - WSUS 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]
(
...