SQL Collection Bonus

Did you know that our SQL Collection category of reports found in Enhanced Web Reporting – EWR will allow you to do more than run reports?
Yes it is true!  Once the SQL Collection is installed, you can also create a CM07 / CM12 collection with all of the PCs that have SQL installed on them.
Here is how you can use the SQL Collection to create a collection of all PCs with SQL 2005 Express installed on them.
High level steps:

• Create a Query just like you would for any other query
• Under the Criteria tab select ES_SQL05 – PropertyStrValue within Where
• Change Operator to is like
• Enter “%Express Edition%” within Value

Your entry should look like the following:

• Next create a collection as you normally would using the query that you just created.

This feature is also available with other Enhanced Web Reporting – EWR collections of reports:

• Computer System
• Keyboard
• Mouse
• Operating System
• Printers
• Services
• Windows Experience Index

And, of course, SQL.