Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
smbios_tables
BIOS (DMI) structure common details and content.
Column | Type | Description |
---|---|---|
description | text | Table entry description |
handle | integer | Table entry handle |
header_size | integer | Header size in bytes |
md5 | text | MD5 hash of table entry |
number | integer | Table entry number |
size | integer | Table entry size in bytes |
type | integer | Table entry type |
SMBIOS tables are used to deliver information from the BIOS to the operating system. Use the md5 field to compare systems and see if their hardware is configured identically.
SELECT * FROM smbios_tables WHERE md5='dd66d84ec724d35db011883052973eae'
This table requires an Intel compatible system.