For environments where there several manufacturers the option to use BIOS tools to gather all information may not be possible. We can guesstimate a system will be UEFI Capable based on the PCBios Date Attribute. We will be generous and system with PC Bios date after 1/1/2013
will be UEFI Capable
UEFI Capable Systems
select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.ReleaseDate, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.ReleaseDate > “1/1/2013 12:00:00 AM”
NOTE: There are more specific ways to identify systems that are UEFI capable but that will require
Creating a new WMI namespace. That method described will only work on certain manufacturers like Dell, Lenovo, HP in a future blogpost
UEFI CAPABLE SYSTEM MODELS
select distinct SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.ReleaseDate > “1/1/2013 12:00:00 AM”
Non-UEFI Capable Systems
select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.ReleaseDate, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.ReleaseDate > “1/1/2013 12:00:00 AM”
Non-UEFI Capable System Models
select distinct SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.ReleaseDate < “1/1/2013 12:00:00 AM”
NOTE: The results from this query will be used later in the WIN 10 task sequence. These models will receive the “Warning: System Not UEFI Capable” step in the task sequence. These are the system models that will not boot UEFI and will receive Windows 10 on a MBR partition
ALSO SEE : Windows 10 Migration Project (General Starter Queries)
Add comment