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.

27 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Michael Griswold shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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