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.
Solutions A small chevron
Device management

Device management

Remotely manage, and protect laptops and mobile devices.

Orchestration

Orchestration

Automate tasks across devices, from app installs to scripts.

Software management

Software management

Inventory, patch, and manage installed software.

GitOps

Fleet Gitops

See every change, under any error, repeat every success.

Extend Fleet

Extend Fleet

Integrate your favorite tools with Fleet.

Customers Pricing
More A small chevron
Try it yourself Get a demo

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

mdm_bridge

click to open the table of contents
Windows logo

mdm​_bridge

Allows querying MDM enrolled devices using "get" commands. Currently, only supports commands that target the device scope. Head to the Windows configuration profiles (CSPs) documentation to verify that the setting support the device scope.

Column Type Description
enrolled_user text Contains the enrollment URI of the device.
enrollment_status text Contains the enrollment status of the device, possible values are "device_enrolled" and "device_unenrolled".
mdm_command_input text The "get" command to execute on the device. If empty, no command is executed and the "enrollment_status" and "enrolled_user" columns are returned.
mdm_command_output text Value of the "Results" field of the MDM command output.
raw_mdm_command_output text The full raw output of the MDM command execution.

Example

Identify Macs that are DEP capable but have not been enrolled to MDM.

SELECT raw_mdm_command_output FROM mdm_bridge WHERE mdm_command_input = '<SyncBody><Get><CmdID>1</CmdID><Item><Target><LocURI>./Device/Vendor/MSFT/Policy/Result/System/AllowTelemetry</LocURI></Target></Item></Get></SyncBody>';

Notes

This table is not a core osquery table. It is included as part of Fleet's agent (fleetd). This table does not work on Windows Server

Edit page

Questions?

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