Solutions
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Infrastructure as code
See every change, undo any error, repeat every success.
Extend Fleet
Integrate your favorite tools with Fleet.
More
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Infrastructure as code
See every change, undo any error, repeat every success.
Extend Fleet
Integrate your favorite tools with Fleet.
Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
Apple
Linux
Windows
ChromeOS
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.