Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Ability to create collections either as WMI(WQL) or SQL based.

Back in the day Altiris had this ability to create collections based on SQL queries. I think this would be great as the provider in some cases work more effictiently and not need to do a translation if the query was already native. Not saying to get rid of WQL, but have the option to select sql based query and a text box to type or paste the SQL query.

35 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Carl Polk shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    From what I can see when running SQL traces, collection evaluations translate the WQL query into SQL anyway when it parses the database, so would only seem logical to use SQL based collection queries anyway. would certainly allow us to write better queries that are more performant.

Feedback and Knowledge Base