ConfigMgr (SCCM) – Methods to Unlock Collections, Packages, and Programs

  • Article

Thought of sharing one of the interesting TechNet thread as it’s not easy to find these details through Google or Bing http://anoopmannur.files.wordpress.com/2012/01/wlemoticon-smile.png?w=600

TechNet Forum Link

Please Note “Editing the DataBase Directly is NOT Supported ”. Always take backup before performing this activity.

Note! Following activities should be performed before attempting any of these changes in SQL tables.

**1. Disable and stop the Windows Management service. (**Don’t forget to enable and start the services http://anoopmannur.files.wordpress.com/2012/01/wlemoticon-smile.png?w=600)

2. Stop both the SMS_EXECUTIVE and SMS_SITE_COMPONENT_MANGER

Extracts from Forum Thread !!! (Note! TMP = site of OLD central site and IT1 = Site code of “Current/Existing” central site)

Collections Repair (Unlock procedure)
I ran the following SQL query to list all of the data in the table Collections:
select * from collections

Noticed that all of the values for the column “Flags” were set to a value of 2 instead of 18. I referenced the following article: http://www.myitforum.com/articles/1/view.asp?id=396 .

I ran the following SQL query to correct a single row and see the result:
*update Collections set Flags=’18′ where SiteID=’IT100A2C’
*

Once I saw that it worked I ran the following query to update all rows who’s name began with IT1 and reset the value to 18.
*update Collections set Flags = ’18′ where SiteID like ‘it1%’
*
Packages Repair (Unlock procedure)
I ran following SQL query to list all of the data in the table SMSPackages:
*select * from SMSPackages
*
I ran the following SQL query to replace all rows with a SourceSite value of TMP and change it to IT1 :
*update SMSPackages set SourceSite=’IT1‘ where SourceSite=’TMP‘
*
**Advertisements Repair (Unlock procedure)
**I ran the following SQL query to list all of the data in the table ProgramOffers:
*select * from ProgramOffers
*

I ran the following SQL query to replace all rows with a SourceSite value of TMP and change it to IT1:
update ProgramOffers set SourceSite=’IT1‘ where SourceSite=’TMP‘

Note – This post is provided “AS IS” with no warranties, confers no rights, and is not supported by the author.