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

preferences

click to open the table of contents
macOS logo

preferences

macOS defaults and managed preferences.

Column Type Description
domain text Application ID usually in com.name.product format
forced integer 1 if the value is forced/managed, else 0
host text 'current' or 'any' host, where 'current' takes precedence
key text Preference top-level key
subkey text Intemediate key path, includes lists/dicts
username text (optional) read preferences for a specific user
value text String value of most CF types

Example

This table reads a huge amount of preferences, including on third-party apps.

SELECT * FROM users CROSS JOIN preferences USING (username);

Notes

  • Querying this table requires joining against the users table. Learn more

  • The value column will be empty for keys that contain binary data.

Edit page

Questions?

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