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