This is our first post in a long while, we've had our heads down ramping up on System Center 2012 and helping the first wave of early adopters. As part of some of the work we've done, we found one common scenario where customers are looking to migrate their server patching from WSUS to System Center 2012 Configuration Manager. For desktop migrations, customer are usually happy to take all updates or the majority of updates and just start fresh. For servers, they want to be sure that they only thing they pull across is whatever was approved by change and release management.
To this end, I've written up a couple of sample scripts that help with this migration. The first script dumps a list of all approvals to all software update groups. The second script takes this list and create Software Update Groups (or Update Lists if you're using 2007) for each computer group with an update per approval. The reason these steps were split was to allow for manual review of the exported list. We found certain updates need clean up prior to importing into WSUS...and some simple Excel clean up does the trick (look for blank fields - these are usually software update titles that have wrapped).
The first script will output the list to console, so you'll need to pipe the script output into another file (powershell.exe script.ps1 > output.csv). The second script will show a progress bar as it imports, and uses a combination of T-SQL to get CI_IDs from the database and WMI via the provide to create the software update group and add the updates to the group.
NOTE: you may end up with more than 1000 updates in a single update group, something we don't recommended for Configuration Manager, so consider either splitting those groups into separate groups or doing some cleanup/fixup in Excel to split the authorizations being imported.
Both scripts can be found on the TechNet Script Center's Repository:
- Export Script: http://gallery.technet.microsoft.com/scriptcenter/Export-WSUS-Approvals-per-59b89a53
- Import Script: http://gallery.technet.microsoft.com/scriptcenter/Import-WSUS-Approvals-into-475bff65
Hopefully these scripts will make your migration to Configuration Manager a little bit easier.
Keep in mind those that these scripts are sample scripts only and should be tested thoroughly prior to use in any production environments.