SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr? SCCM/ConfigMgr dynamic collection query can be evil in some scenarios. It’s very easy to make mistakes while editing already existing dynamic queries.

Related Post – SCCM Dynamic Collection – Part 2 | WQL Query | ConfigMgr | Create HTMD Blog (anoopcnair.com)

It’s better with device-based dynamic collections (as it gives a warning pop up, as you can see in the above video!) in the SCCM CB environment. Still, it’s not a very good user-based dynamic user collection.

I have created a quick video to demonstrate this issue here. I have Kannan C S to share his experience on this topic. He is a Sr. Infra Architect with several years of SCCM and System Center experience. I will let Kannan C S explain his experience in detail.

Patch My PC

Introduction

I’m Kannan C S, and working as Sr. Infra Architect in a leading IT Company having 15 years of IT experience. I have been with Configuration Manager [Designing, Implementation, Migration, and Support], System Center Orchestrator [Designing and Implementation], and Windows Server support. You can refer to my blog here.

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

I have seen the dynamic collection query update issues in different organizations. Mainly with L1 and L2 teams where we don’t have real SCCM expertise.

I have already created a user voice item. Please vote this up User Voice – Collection Query

Known Issue?

I am looking at the issue/design from SMS 2003 to SCCM 2012 (even SCCM CB) version. I am not sure if any purpose must be behind this design of collection default query select * from sms_r_system/select * from sms_R_User. Suppose a user creates the query-based device or user collection if there is any modification in the query. They should remove the entire query and apply OK.

If a user applies ok, it’s automatically select * from sms_r_system/select * from sms_R_User query will enable, it will be targeted to all system which is “All system”/”All Users” as limiting collection.  It has serious issues in most companies; deployment is performed by L1 or L2 engineers.

It is nowhere documented in the MS TechNet or Blog. I would strongly recommend having some mechanism to avoid this kind of change in upcoming released.

I have provided the impact below screenshots,  When modifying the collection query, Click edit:-

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

Click Edit Query Statement

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

Click Show Query Language

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

Select the entire query in the Query Statement dialog box. Click Delete

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr 1
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

Click OK

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr 2
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

By default it will return with Select * from SMS_R_System/select * from sms_R_User query. By then, the deployment targeted to a specific collection will be mapped to All devices, including workstations and servers.

SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr 3
SCCM Dynamic Collection Query Update Known Issue | Configuration Manager | ConfigMgr

Resources

SCCM Dynamic Collection – Part 2 | WQL Query | ConfigMgr | Create HTMD Blog (anoopcnair.com)

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about 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.