We're currently evaluating SCCM for use in deploying software and managing our machines. We currently use a different enterprise solution, and are attempting to do a little bit of a feature comparison...
One thing we currently do in our current system, is build collections based on SQL. SCCM appears to have this ability, but our first impression tells us it's actually using WQL, and not actually connecting to the SCCM SQL database.
One real-life scenario where we would utilize SQL over WQL, is with our blackberry users. We have a SQL collection that joins to our BES database, and automatically builds the collection of users that should get the "blackberry desktop" software on their workstation.
Since SCCM is based on WQL, is there a way to connect to a database in this way? Or can you only connect to the WMI tables that SCCM can see?