KQL Search

Query Details

Old BIOS Versions

Query

// Identify BIOS versions older than 1 year
BiosInfo
| where ReleaseDateTime < ago(365d)
| project Manufacturer, SmBiosVersion, ReleaseDateTime

Explanation

This query is designed to find BIOS versions that are older than one year. It does this by looking at a data source called BiosInfo and filtering out entries where the ReleaseDateTime (the date when the BIOS was released) is more than 365 days ago. After filtering, it selects and displays three pieces of information for each of these older BIOS versions: the Manufacturer, the SmBiosVersion (the version of the BIOS), and the ReleaseDateTime.