Sccm query based collections not updating
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.
You might simply see the hour glass on the collections, Generally nothing was changed on existing collections but a new collection might have been added.
I have created a quick video to demonstrate this issue here.
I have got a blogger Kannan C S to share his experience on this topic. Infra Architect with several years of SCCM and System Center experience.
Example: Your environment contains the following collections.
Nurses Room101Nurses Room102Nurses Room103Nurses Room104Nurses Room105..
The raw SQL for this type of query is provided in taylord1's answer. I will let Kannan C S explain his experience in details. Infra Architect in leading IT Company having 15 years IT experience.I have been with Configuration Manager [Designing, Implementation, Migration and Support], System Center Orchestrator [Designing and Implementation], Windows Server support. I am looking the issue/design from SMS 2003 to SCCM 2012 (even SCCM CB) version.It’s better with device based dynamic collections (as it gives a warning pop up as you can see in the above video!) in SCCM CB environment but it’s not very good user based dynamic user collection.