WSUS: Failed to run WSUS Server Cleanup. Error: The DELETE statement conflicted with the REFERENCE constraint

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

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

DHCP Option 119 – DNS Search Suffix – PowerShell Array Builder

Although Microsoft clients may not support DHCP Option 119, it is nonetheless a very important option for Linux and OSX clients. However, configuring such an option is not exactly the friendliest thing in the world. The RFC 3397 (http://tools.ietf.org/html/rfc3397) defines the standard. It requires that all options be presented as a byte array. One of
Continue reading DHCP Option 119 – DNS Search Suffix – PowerShell Array Builder

Assigning permissions to a volume through the NetApp PowerShell Toolkit

As part of my work to automate as much as I can, both to reduce time and increase consistency, I was looking for a way to assign permissions to a newly created volume which was providing a CIFS share through our NetApp FAS unit. Normally I would use the Get/Set-Acl cmdlets that are provided through
Continue reading Assigning permissions to a volume through the NetApp PowerShell Toolkit

Using Add-Type in a PowerShell script that is run as a Scheduled Task

I like using objects in PowerShell, they make management and scripting easier as your are dealing with named sets of information and not having to find objects in numbered arrays or use dictionaries. That means however that a lot of my scripts start off with a block that looks a little like this: $UserDefinition =
Continue reading Using Add-Type in a PowerShell script that is run as a Scheduled Task