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.
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Docs
Stories
News Ask around Schedule a demo Share your story COMPANY The handbook What people are saying
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

macos_profiles

click to open the table of contents
macOS logo

macos​_profiles

High level information on installed profiles enrollment.

Column Type Description
description text The description of the profile.
display_name text The display name of the profile.
identifier text The identifier of the profile.
install_date text Date and time at which the profile was installed.
organization text The profile's organization value.
type text The type of profile.
uuid text The UUID of the profile.
verification_state text The verification state of the profile.

Example

Identify all profiles that are not verified.

SELECT display_name, install_date FROM macos_profiles WHERE verification_state!='verified';

Notes

This table is from the Mac Admins osquery extension.

Edit page

Questions?

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