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. THese will be systems that are secureboot capable systems. it is important to know what systems in environtment will be secure and non secure.
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 Labels: Query, SCCM, UEFI, Windows 10