Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Make it simpler to author collection query rules

Create a tool to allow the translation of a SQL query back into WQL that can be used in a collection. Alternatively, change the WQL wizard to be more useful and similar to the SQL management studio.

31 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Michael Griswold shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
An error occurred while saving the comment
  • Dieter commented  ·   ·  Flag as inappropriate

    This would help us a lot to speed up performance. Each of our 1500 Collection has a query that looks like .... attribute=value .... and each query takes about 2.5s as shown in CEViewer (>200000 machines in collection). So it can take an hour to evaluate all collections since all queries are processed by the same thread in collection evaluator (Full Evaluation queue).
    When i look at the corresponding SQL query that returns the same set of resource ids this takes just 100ms. I think there is a lot of overhead in WQL processing and i have no clue how that could be improved.

    SQL as a supported collection query language would also improve a lot the integration of our fore-front client management in SCCM. We could query the fore-front client management system directly for a machines applications and return the machine ids to the SCCM collection without any delay after the application assignment has changed in the fore-front system!

  • Anonymous commented  ·   ·  Flag as inappropriate

    At present only WQL can be used to create Collections and Queries. We should be able to use SQL Queries to be able to do this - lots of us have SQL skills that allow us to generate SSRS reports ourselves, but we cannot use the TSQL we generate to create collections - so for example, creating a dynamic collection to contain devices that need a specific patch is not easy, if indeed it is possible.
    In addition, we often have to close a query window and run the query to see if what we have done in the query is corect - having a preview button within Query and Collection creation windows would be very beneficial.
    John
    John

Feedback and Knowledge Base