KQL Search

Query Details

Identify Devices With Outdated BIOS

Query

// This query identifies devices with a BIOS release date older than 1 year.
BiosInfo
| where ReleaseDateTime < ago(365d)
| project Device, Manufacturer, SmBiosVersion, ReleaseDateTime

Explanation

This query is designed to find devices that have a BIOS release date older than one year. It does this by:

  1. Accessing the BiosInfo data table.
  2. Filtering the records to include only those where the ReleaseDateTime (the date the BIOS was released) is more than 365 days ago.
  3. Displaying the results with specific details: the Device name, Manufacturer, SmBiosVersion, and the ReleaseDateTime.

Details

Ugur Koc profile picture

Ugur Koc

Released: February 28, 2025

Tables

BiosInfo

Keywords

DevicesBiosReleaseDateTimeManufacturerSmBiosVersion

Operators

whereagoproject

Actions

GitHub