I received the following error when running the ‘Invoke-WsusServerCleanup -CleanupObsoleteComputers’ command on a WSUS instance. From searching through the database the problem appears to have been caused by a computer changing its Target Computer Group, but not being completely unassigned from the old computer group. Failed to run WSUS Server Cleanup. Error: The DELETE statement
Continue reading WSUS: Failed to run WSUS Server Cleanup. Error: The DELETE statement conflicted with the REFERENCE constraint
Tag: WSUS
WSUS Update Manager – Manage & View Updates for Computer Groups
One of the most annoying flaws in the WSUS MMC snap-in is how the filter for Approval status filters updates on whether they have any approvals rather than whether they are approved for a specific computer group. We found out that due to an automatic approval rule for a test group, a whole group of
Continue reading WSUS Update Manager – Manage & View Updates for Computer Groups
WSUS: Copy Updates Between Groups
So, I am restructuring some WSUS groups to make them easier to report on, but I already had a large number of approvals on one group that I wanted to retain. There are already a few interpretations of this on the web, but none that in my opinion are as slick as this, or provide
Continue reading WSUS: Copy Updates Between Groups