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
managed_policies
managed_policies
The managed configuration policies from AD, MDM, MCX, etc.
| Column | Type | Description |
|---|---|---|
| domain | text | System or manager-chosen domain key |
| manual | integer | 1 if policy was loaded manually, otherwise 0 |
| name | text | Policy key name |
| username | text | policy only applies to the listed user. Blank if global. |
| uuid | text | Optional UUID assigned to policy set |
| value | text | Policy value |
Example
Check if critical software update installation is enabled via a profile (1 = enabled)
SELECT name, value FROM managed_policies WHERE domain='com.apple.SoftwareUpdate' AND name='CriticalUpdateInstall' LIMIT 1;
Edit page
Ask us anything
Questions?
SOC2 Type 2
© 2025 Fleet Inc.
Privacy
