How to Unlock ConfigMgr SCCM Collections Packages and Programs

How to Unlock ConfigMgr SCCM Collections Packages and Programs. I thought of sharing one of the interesting TechNet threads, as finding these details through Google or Bing is difficult.

Collections enable you to generate a group of machine(s) with similar characteristics. These collections can then be used to deliver software or build queries. By default, you will have a top-level collection that includes all the MECM-installed systems in your department.

Application packaging in SCCM is making and packaging a software installation in a format that can be delivered and installed on devices within an organization. The package is one of the oldest workloads in SCCM.

Like the application, the package has Summary, Programs, and Deployment tabs at the bottom of the console window. The tabs show which package is deployed to which Collection and the Program tab gives details regarding command lines.

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

• Enable Notification for SCCM Package Deployment
• How to Disable SCCM Package Deployment
• SCCM Package Deployment Options in Distribution Points Tab
• Set SCCM Software Center Icon for Task Sequences Packages

Index
Prerequisites- How to Unlock ConfigMgr SCCM Collections Packages and Programs
Collections Repair (How to Unlock ConfigMgr SCCM Collections Packages and Programs)
Advertisements Repair (How to Unlock ConfigMgr SCCM Collections Packages and Programs)

Prerequisites- How to Unlock ConfigMgr SCCM Collections Packages and Programs

Before attempting any of these changes in SQL tables, the following activities should be performed.

• Disable and stop the Windows Management service. (Don’t forget to enable and start the services ).
• 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 (How to Unlock ConfigMgr SCCM Collections Packages and Programs)

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‘

• Export SCCM Package Using Package Wizard | PowerShell
• Deep Dive SCCM Application Model Client End Troubleshooting
• SCCM Application Model Server Side Troubleshooting
• Free ConfigMgr Training Part 2 | 20 Hours Of Technical | SCCM

Advertisements Repair (How to Unlock ConfigMgr SCCM Collections Packages and Programs)

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.

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair has been Microsoft MVP from 2015 onwards for 10 consecutive years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is also a Blogger, Speaker, and leader of the Local User Group Community. His main focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career, etc..