Getting the Model name for our Lenovo machines can be usefull when we need to download drivers and create WMI query for our Driver Packs in the Task Sequence. Because we are using Driver Packs right.. I mean if you want controll.
Lenovo puts their Model name information in ComputerSystem Product, so we need to enable that in Class information in our Hardware Inventory for Workstations. Like this:
Now after the Clients have got the new policy and run a new Hardware Scan you will get this information from Configmgrs database with this Query: ( if you dont want to wait you could use a right click tool like "Now Micro Right Click Tools" to trigger that scan right a way.
As you see in the back we will Product Version that gives us the model like "ThinkCentre M90".
This is a copy of the Query:
select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.IdentifyingNumber, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM_PRODUCT on SMS_G_System_COMPUTER_SYSTEM_PRODUCT.ResourceID = SMS_R_System.ResourceId