Deploying a driver package during OSD using wmi query NOT based on model

Question

_{Wednesday, March 12, 2014 10:31 AM}

Hello everyone,

I have the following situation. I am deploying HP Elitebook Revolve 810 notebooks with Win7 via SCCM Tasksequence. Recenty HP updated this line of notebooks, giving it the prodúct name "HP Elitebook Revolve G2". They also released a new driver management package for all their new business notebook, such as the 820 G1, 640 G1 and Zbooks.

This driverpackage also supports the HP Elitebook Revolve G2 notebooks, but not the HP Elitebook Revolve G1.

The problem now is as follows: I use a wmi query to apply the driver package for the ZBooks, Elitebooks, Revolve G2 and Probooks that looks like this: 

If any SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%810 G2%"SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%820%" SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%640%"
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%zbook%"

For the older Elitebooks Revolve 810 i use the following:
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%810%"

This is because the older models have the model names “Revolve 810 G1” and “Revolve 810” without the G1.

Now when when in run my OSD and I have a 810 G2 notebook it installs both driver packages.

Does someone have a hint for me what key or class I might be able to query which is unique to the 810 G1 notebooks? Or some other way to get around this?

Thanks in advance

Gert

All replies (5)

_{Wednesday, March 12, 2014 11:27 AM ✅Answered | 1 vote}

You can add a "If Statement" with parameter set to "All conditions".

Then under that you'll have 2 WMI Queries:

SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%810%"

and 

SELECT * FROM Win32_ComputerSystem WHERE Model != "%810 G2%"

Should solve your issue

_{Wednesday, March 12, 2014 11:29 AM ✅Answered}

For the exclusion you can also have:

SELECT * from Win32_ComputerSystem WHERE NOT Model LIKE "%810 G2%"

_{Wednesday, March 12, 2014 12:57 PM}

Yeah thanks gonna try this, should indeed be the answer, so simple yet effective :) Thanks alot

_{Wednesday, March 12, 2014 1:49 PM}

You can also use OR in your WHERE clause:

WHERE Model LIKE "%640%" OR Model LIKE "%zbook%

Jason | http://blog.configmgrftw.com

_{Saturday, September 13, 2014 6:48 PM}

Hi Gert

I have an OSD issue with Revolve G2 to deploy win 7 sp1 x64. With revolve 810 G1 everything was working. I took the driver package for zbooks too but it always fails

after step setup setup windows and configmgr etc. Can you let me know how your bios of g2 looks like?

The Revolve G2 contains msata disk.  I don't know if there is a difference. I tried different .wim files with and without containg windows update but no success.

Any ideas?