Collection Query re-design request
I am looking the issue/design from SMS 2003 to SCCM 2012 version. I am not sure if any purpose must be behind of this design of collection default query select * from sms_r_system.
Whenever a user create the query based device collection, if there is any modification in the query
He/she shouldn’t remove the entire query and apply OK.
If user applies ok, its automatically select * from sms_r_system query will enabled, it will targed to all system which is “All system” as limiting collection.
It has serious issue in most the companies, deployment is performing by L1 or L2 engineers.
It is nowhere document in the MS TechNet or in Blog.
I would strongly recommend to have some kind of mechanism to avoid this kind of changes in upcoming released.
You can reach me on email : firstname.lastname@example.org if you need any clarification.
Fixed in #SCCM 1902 which shipped today.
Hi DJ, let me know if you require any more information on the task
Hi DJ, yes, that correct. If they click OK, in empty query dialog box, it will returns as select * from sms_r_system by default.
Anoop C Nair commented
Hi DJ ! - I'll let kannan to explain this in detail. However, I just created a short video (No audio :) ) https://www.youtube.com/watch?v=LSmiQA53CUw about the device and user collection query behaviors. May be this will help you to understand better. For device collection there is a warning message I would say that is good start (I really don't know that serves the purpose or not) . I liked the warning message and that will help the L1 or L2 to get some hint of what they are going to do. But there is no such warning message for user collections.
Craig Wilson commented
Could this idea be expanded so that the default query is for the "Limited Collection" rather than All Systems?
This is actually a pain area, MS has to redesign the way it works.
Rob Marsiglia commented
Kannan, I see what you mean. As a test I edited an existing collection's query. While editing the query i removed the existing query statement and clicked OK without entering in any query information. The default query then became "Select * from SMS_R_System". If there was anything already deployed to the collection, it would spread outside of the intended scope of the initial query.
If approved, this requested change would prevent unintended deployments due to user error.