 
              
              
              
              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.
 
                          Extend Fleet
Integrate your favorite tools with Fleet.
Customers
 
                       
                          Stripe + Fleet
Stripe consolidates multiple tools with Fleet.
 
                          Foursquare + Fleet
Foursquare quickly migrates to Fleet for device management.
 
                          What people are saying
Stories from the Fleet community.
More
 
                      Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
 Apple
            Apple
             Linux
              Linux
             Windows
              Windows
             ChromeOS
              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.