Category Archives: Configuration

SCCM 2007 – OSD Configuration – Task Sequence WMI Query for Lenovo ThinkPads

During the imaging process, it becomes necessary to provide WMI queries within task sequences in order to differentiate between computer models. Typically, this is accomplished by utilizing the following query within a conditional statement inside a task sequence task item:

SELECT * FROM Win32_ComputerSystem WHERE Model = “[model name from WMI]”

Unfortunately, if you are using Levono products, this can have multiple values for the same computer familiy. (i.e.  the ThinkPad X61 has several different model “numbers,” none of which have the label “ThinkPad X61”.) In order to provide a query which will yield the commonly used model “name” for Lenovo Thinkpads, use the following query:

SELECT * FROM Win32_ComputerSystemProduct WHERE Version = “ThinkPad [model number]”

(i.e. SELECT * FROM Win32_ComputerSystemProduct WHERE Version “ThinkPad X200”)

It is also very handy to keep a spreadsheet of all the model numbers and corresponding model names for use in reporting CASE statements to make your reports easier for management to decipher.