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.
~Agreed! I should be able to copy my SQL query and past it in a collection!
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!
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.