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.
Pricing
More
Tables
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
os_version
os_version
A single row containing the operating system name and version.
| Column | Type | Description |
|---|---|---|
| arch | text | OS Architecture |
| build | text | Optional build-specific or variant string |
| codename | text | OS version codename |
| extra | text | Optional extra release specification Not returned in SELECT * FROM os_version.Only available on darwin |
| install_date | bigint | The install date of the OS. Only available on Windows |
| major | integer | Major release version |
| minor | integer | Minor release version |
| mount_namespace_id | text | Mount namespace id Only available on Linux |
| name | text | Distribution or product name |
| patch | integer | Optional patch release |
| pid_with_namespace | integer | Pids that contain a namespace Only available on Linux |
| platform | text | OS Platform or ID |
| platform_like | text | Closely related platforms |
| revision | integer | Update Build Revision, refers to the specific revision number of a Windows update Not returned in SELECT * FROM os_version.Only available on windows, win32, and cygwin |
| version | text | Pretty, suitable for presentation, OS version |
Example
See the OS version as well as the CPU architecture in use (X86 vs ARM for example)
SELECT arch, version FROM os_version;Notes
- On ChromeOS, this table requires the fleetd Chrome extension.
Questions?
SOC2 Type 2
