Use CMPivot Query to Find BIOS Details in SCCM

This article will demonstrate how to use a CMPivot query to retrieve BIOS information, including manufacturer and version, for all of your Windows devices that are SCCM-managed.

While auditing an organization’s SCCM setup, I was asked if it was possible to obtain BIOS information such as the manufacturer and version of devices using SCCM. This organization wanted to upgrade the BIOS of devices that had not been updated in many years.

Yes, it is possible to retrieve the BIOS information from devices because we know SCCM collects hardware data from devices. A CMPivot query can reveal most of your device’s BIOS details, which is useful for an organization. This information can tell you how many of your devices are running a specific version of BIOS.

Examples of CMPivot queries that we have covered so far include:

• Use SCCM CMPivot Query to Find Installed Patches in Days
• Find Anti-malware Software Status using CMPivot Query in SCCM
• Find Recently Used Applications using SCCM CMPivot Query
• CMPivot Query to Find TPM Status and Details

Ways to gather the BIOS information

From what I know, there are multiple ways to determine the BIOS details of your device:

• One can manually enter the BIOS mode on a device and find the manufacturer and version of the BIOS.
• The built-in system information tool on Windows shows the BIOS version and the manufacturer.
• When using SCCM, a SQL query can also help you check the BIOS details of your devices.
• Lastly, a CMPivot query can quickly find out the BIOS information from your devices in SCCM.

CMPivot uses the KQL (Kusto Query Language) and it runs the query in real time on all currently connected devices in a selected collection.

Also See: Find Default Browser using SCCM CMPivot Query

List of BIOS Manufacturers

To use the CMPivot query to determine the BIOS manufacturer, you must first know the name of the manufacturer. You’ll need to enter the name of the BIOS manufacturer in the query before you run it.

Some of the more popular BIOS and motherboard vendors are as follows: Some of the more popular BIOS and motherboard vendors include:

• American Megatrends (AMI)
• Asus
• Dell
• Foxconn
• Hewlett Packard (HP)
• IBM
• Phoenix Technologies
• Ricoh
• Insyde Software

Useful Guide: CMPivot Standalone App Deployment Guide using SCCM

Find BIOS details using CMPivot Query

Here is how you can find the BIOS details of your device using a CMPivot query: Launch the SCCM console and navigate to Assets and Compliance > Overview > Device Collections. Right-click a device collection and select Start CMPivot.

Once the CMPivot tool launches, switch to the Query tab and enter the below query to find the BIOS details.

Bios

When you run the above query, the CMPivot query output shows the following BIOS details:

• Device
• Name
• Manufacturer
• Version
• Release Date
• Serial Number
• SMBIOS BIOS Version

Find BIOS Manufacturer using CMPivot Query

Here is how you can find the BIOS manufacturer of your devices using a CMPivot query: Launch the SCCM console and navigate to Assets and Compliance > Overview > Device Collections. Right-click a device collection and select Start CMPivot.

Once the CMPivot tool launches, switch to the Query tab and enter the below query to find the BIOS manufacturer.

Make sure you enter the name of the BIOS manufacturer before running the query.

Bios  | where Manufacturer like '%BIOS Manufacturer Name%'

For example, the below SCCM CMPivot query lists all the devices whose BIOS manufacturer is ‘Alienware.’

Bios  | where Manufacturer like 'Alienware'

The below CMPivot query lists all the devices whose BIOS manufacturer is ‘Dell‘

Bios  | where Manufacturer like 'Dell'

The below CMPivot query lists all the devices whose BIOS manufacturer is ‘HP‘

Bios  | where Manufacturer like 'HP'

The below CMPivot query lists all the devices whose BIOS manufacturer is ‘ASUS.’

Bios  | where Manufacturer like 'ASUS'

CMPivot Query to find devices with a specific BIOS version

If you want to find out the devices that are running a specific version of BIOS, you can use the below CMPivot query. Make sure you enter the BIOS version before running the query.

Bios  | where SMBIOSBIOSVersion like '1.17'