Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Docs
Stories
What people are saying News Ask around Take a tour Meetups COMPANY Origins   (Fleet & osquery) The handbook Logos/artwork Why open source?
Pricing Try it yourself

Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

os_version

click to open the table of contents
macOS logo Windows logo Linux logo ChromeOS logo

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
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

Edit page

Questions?

Ask us anything
{{table.title}} evented table