Monday, November 7, 2011

SCCM - WMI


SCCM Task Sequence Options - WMI Query for Manufacturer and Model:



Dell  WMI

This group/step will run if the following conditions are met:

WMI Query select Manufacturer from Win32_ComputerSystem where Manufacturer = "Dell Inc."

If Any of the conditions are true:
WMI Query select Model from Win32_ComputerSystem where Model = "Latitude D620"WMI Query select Model from Win32_ComputerSystem where Model = "Latitude D830"

BIOS
select * from WIN32_BIOS where SMBIOSBIOSVersion < “A02″

Manufacturer

SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%Dell%"

Model
Select * from Win32_ComputerSystem where Model like "Precision%"


Example of Upgrading Dell Bios:
-----
Dell Patch Bios and Bios upgrade (if Dell Bios is A01 then run Patch first, then Bios upgrade)
(Some models need the Patch first to correctly upgrade BIOS)
Select * from Win32_ComputerSystem where Model like "Latitude E6510%"
select SMBIOSBIOSVersion from Win32_BIOS where SMBIOSBIOSVersion = "A01"

----
Select * from Win32_ComputerSystem where Model like "Latitude E6510%"
select SMBIOSBIOSVersion from Win32_BIOS where SMBIOSBIOSVersion < "A10"

---





WMI for Virtual environments

WMI Query for VMware: select Model from Win32_ComputerSystem where Model = "VMware Virtual Platform"
WMI Query for Microsoft Virtual Server 2005: select Model from Win32_ComputerSystem where Model = "Virtual Machine"





If you are using MDT integration and the model name is badly formatted, the “Task Sequence variable” doesn’t support “like”, therefore, you must use WMI, instead, which does support the “like” statement and will allow us to use the wildcard “%”

Example: Select * from Win32_ComputerSystem WHERE model like “9640%”

If you are not using MDT integration, you must use WMI

Example: Select * from Win32_ComputerSystem WHERE model like “9640%”

No comments:

Post a Comment