Migrating from WSUS to #SCCM / #Configmgr 2012
Posted by Eswar Koneti on August 30th, 2012
Hi Everyone,
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.
For complete Post ,please Read http://blogs.technet.com/b/manageabilityguys/archive/2012/08/25/migrating-from-wsus-to-configuration-manager.aspx