Query Library
Query Library
| Name | Description | Query Type |
|---|---|---|
| Computer Model Counts Query |
Query will list computer model counts in your environment, successfully handling Lenovo sytem model names. It also normalizes vendor names to avoid duplicate model lines (IE "HP" and "Hewlett-... |
SQL Query |
| ConfigMgr DB - Lenovo BIOS Versions (SQL) |
The following query will give a list of Lenovo machines with their model name (not build), and BIOS versions from the CM_ DB. |
SQL Query |
| Find Physical Disk Serial Numbers (SQL) |
Returns a list of serial numbers for physical disks from the ConfigMgr database. |
SQL Query |
| Model Collection Query |
Replace with the output of "wmic csproduct get name" on the model of PC you want to create a collection for. |
Collection Query (WQL) |
| Model Filter Query |
Use for filtering task sequence steps to specific PC models during a task sequence. Replace with output of "WMIC CSProduct Get Name" from the model in question. If you use this on a Lenovo/IBM... |
WMI Query |
| Model Filter Query (Lenovo/IBM) |
Use for filtering task sequence steps to specific PC models during a task sequence. Replace with output of "WMIC CSProduct Get Name" from the model in question. Only use this on Lenovo/IBM... |
WMI Query |
| SCEP Engine Version |
This query will return a list of your workstations and the version of the SCEP engine last reported for each. It does not show workstations that have never reported SCEP data. |
SQL Query |
| Top SQL Queries for CPU Time |
Displays the top X running SQL Queries for CPU TIme. |
SQL Query |
Vendor Links
 |
 |
 |
 |