Monitor Intune devices with old BIOS versions using Intune device query

In this post I will share some KQL queries allowing you to monitor BIOS versions status on your Intune device through the Intune device queries feature.

Context

Microsoft implemented a really cool feature allowing you to gather details about your Intune devices.

You can access it as below:

You have a table about BIOS called BiosInfo.

This table will give you insight about BIOS version and release date on your Intune devices.

This way your can monitor which devices have BIOS installed since more than x days, like 365 days.

Identify Devices with old BIOS versions

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

See below the query:

See below the result:

Identify devices with old BIOS by manufacturer

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

We want to have number of devices by manufacturer

See below the query:

See below the result:

Identify devices with old BIOS by model

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

We want to have number of devices by model. 

See below the query:

See below the result:

Identify devices with old BIOS by Manufacturer and Model

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

We want to have number of devices by manufacturer and model. 

See below the query:

See below the result:

Identify devices with old BIOS by model and BIOS version

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

We want to have number of devices by model and BIOS versions. 

See below the query:

See below the result:

Identify devices with old BIOS by model and BIOS version

Here we want to monitor devices where BIOS release date is older than 1 year (365 days).

We want to have number of devices by model and BIOS versions. 

We want to see nimber devices by BIOS days old, as below:

- Number of devices where BIOS release date is < 2 months

- Number of devices where BIOS release date is < 6 months

- Number of devices where BIOS release date is < 1 year

- Number of devices where BIOS release date is between 1 and 2 years

- Number of devices where BIOS release date is > 2 years

See below the query:

See below the result: