Client computers can no longer synchronize with Windows Server Update Services after you import many third-party product updates

# enum-local-categories.ps1
# tprabhu 20071019 - WSUS v. 3.1

# Load administration
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.UpdateServices.Administration') | out-null


# Create update server
write-host "<<< Connecting to WSUS server >>>" -foregroundcolor "yellow"
$updateServer = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer()

# Get all categories
write-host "<<< Getting all categories >>>" -foregroundcolor "yellow"
$categories = $updateServer.GetUpdateCategories()

# Print out the local 'Company' categories
write-host "<<< Dumping locally published company categories >>>" -foregroundcolor "yellow"
write-host " Company categories "
write-host " ================== "
write-host ""
$i = 1
foreach ($category in $categories)
{
  if ($category.Type -eq [Microsoft.UpdateServices.Administration.UpdateCategoryType]::Company)
  {
    if ($category.UpdateSource -eq [Microsoft.UpdateServices.Administration.UpdateSource]::Other)
    {
      write-host "  Category #" $i
      write-host "  ------------ "
      write-host "   ID    = " $category.Id
      write-host "   Title = " $category.Title
      write-host "   #Subcategories = " $category.GetSubcategories().Count
      write-host "   #Updates = " $category.GetUpdates().Count
      write-host ""
      $i++
    }
  }
}

trap
{
	write-host "Error Occurred"
	write-host "Exception Message: " 
	write-host $_.Exception.Message
	write-host $_.Exception.StackTrace
	exit
}

# EOF

# delete-update-in-category.ps1
# tprabhu 20071019 - WSUS v. 3.1

# Load administration
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.UpdateServices.Administration')

# Create update server
write-host "<<< Connecting to WSUS server >>>" -foregroundcolor "yellow"
$updateServer = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer()

# Get all categories
write-host "<<< Getting all categories >>>" -foregroundcolor "yellow"
$categories = $updateServer.GetUpdateCategories()

# Delete updates belonging to a category
write-host "<<< Ready to delete all updates that belong to a category >>>" -foregroundcolor "yellow"
$categoryToDelete = read-host "Enter category Id"
write-host " All updates belonging to category " $categoryToDelete " will be deleted!"
$sure = read-host " Continue? (y/n)"

if ($sure -ne "y")
{
  exit
}

# Get all updates that belong to category
write-host ""
write-host "<<< Searching for updates belonging to category >>>" -foregroundcolor "yellow"
foreach ($category in $categories)
{
  if ($category.Id.ToString() -eq $categoryToDelete)
  {
    $updatesInCategory = $category.GetUpdates()
    break
  }
}

foreach ($update in $updatesInCategory)
{
  write-host "Deleting update " $update.Id.UpdateId "..."
  $updateServer.DeleteUpdate($update.Id.UpdateId)
  write-host " Done!"
}

write-host ""
write-host "All updates belonging to category " $category.Id.ToString() " are deleted"

trap
{
	write-host "Error Occurred"
	write-host "Exception Message: " 
	write-host $_.Exception.Message
	write-host $_.Exception.StackTrace
	exit
}

# EOF