Querying Dell Monitor Information in SCCM

Mike Terrill has a most excellent blog post on how to get Dell BIOS/UEFI information into WMI/SCCM. It involves setting up Dell Monitor, and then using SCCM to import a custom hardware class. You can find all the info here: https://miketerrill.net/2016/05/08/how-to-inventory-dell-bios-and-uefi-settings-with-configmgr-part-1/

If you would then like to create a membership query on that info, here is an example checking to see if its set to BIOS or UEFI mode. A “CurrentValue” of 1 is BIOS, 2 is UEFI. So in this example, we want to return all machines with UEFI enabled.

First is the WQL Query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_DCIM_BIOSENUMERATION on SMS_G_System_DCIM_BIOSENUMERATION.ResourceId = SMS_R_System.ResourceId where SMS_G_System_DCIM_BIOSENUMERATION.AttributeName = “Boot Mode” and SMS_G_System_DCIM_BIOSENUMERATION.CurrentValue = “2”

Here is a screenshot if you want to build it:


Filed under: Uncategorized | Posted on May 26th, 2016 by CharlieMaurice

Leave a Reply

RSS Feed





Copyright © 2017 Charlie's Tech Ramblings. All rights reserved.

Tech Blue designed by Hive Designs • Ported by Free WordPress Themes