How to Unlock SCCM ConfigMgr Collections Packages and Programs

How to Unlock SCCM ConfigMgr Collections Packages Programs Endpoint Manager. I thought of sharing one of the interesting TechNet threads as it’s not easy to find these details through Google or Bing. TechNet Forum Link.

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

Latest Post – Free ConfigMgr Training Part 2 | 20 Hours Of Technical | SCCM HTMD Blog (anoopcnair.com).

How to Unlock SCCM ConfigMgr Collections Packages Programs Endpoint Manager?

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

Patch My PC

1. Disable and stop the Windows Management service. (Don’t forget to enable and start the services )

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)

1E Nomad

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

I noticed that all of the column “Flags” values 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 saw the result:
update Collections set Flags=’18’ where SiteID=’IT100A2C’

Once I saw it worked, I ran the following query to update all rows whose names began with IT1 and reset the value to 18.
update Collections set Flags = ’18’ where SiteID like ‘it1%’

Packages Repair (Unlock procedure)I ran the 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.

Author

Anoop is Microsoft MVP! He is a Solution Architect on enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, Intune. He writes about technologies like ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.…

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.