Collections can be used to deploy Software, Operating Systems, Task Sequences or settings to these managed groups.
Basics covered, we all now know what a collection is and what it’s for.
One of the common issues i have seen over the years when all of a sudden the collections would not refresh and collection membership would not update. Client0 from System_DISC AS SMS_R_System INNER JOIN v SMS_G_System_Software File AS SMS_G_System_Software File ON SMS_G_System_Software File. Item Key INNER JOIN Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMS0 ON __System_ADD_REMOVE_PROGRAMS0.
According to Technet ( Collections in System Center 2012 Configuration Manager provide a method of managing groups of computers, mobile devices, users, and other resources in your organization.Use the SQL Management Studion and Connect to your SCCM/SMS Database insert into #Coll Temp (Machine ID, Architecture Key, Name, SMSID, Domain , Is Client) select all SMS_R_SYSTEM. This script is tested on these platforms by the author. If you try it and find that it works on another platform, please add a note to the script discussion to let others know.Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2 Collections that are based on direct-membership rules need to be manually updated by the Configuration Manager administrator (in the same manner as each resource was originally added to the collection when it was created).Collections that are query-based, however, can be automatically updated by Configuration Manager.There are four ways collections can get their membership rules updates: When creating a collection through the console then this will be the default setting.