The Schema Reference
- Click 'Assets' > 'Endpoint Intelligence' > 'Device Queries', then click 'Schema' at the top right.
The reference opens as a 'SCHEMA REFERENCE' panel down the right of the screen and lists every table you can query, with the platforms each one works on.
You can search the tables, filter them by platform and insert one straight into your query.
A table row
| Column | Description |
| ▶ (the chevron) | Expands the table to show its columns. |
| (the table name) | The name you use in the FROM clause of your query. |
| + | Inserts the table into the query editor. |
| L / M / W | Platform badges: L for Linux, M for macOS, W for Windows. A table can carry more than one. |
The Saved and History panels
The 'Saved' and 'History' buttons beside 'Schema' each open a panel above the query form instead.

| Column | Description |
| Saved | The queries you have stored with 'Save Query'. Empty state: 'No saved queries yet.' |
| History | The queries you have run. Empty state: 'No query history yet.' |
Build a query from the schema
- Click 'Assets' > 'Endpoint Intelligence' > 'Device Queries'.
- Click 'Schema'.
- Click the platform button for the operating system you are querying, to hide the tables that do not exist there.
- Type part of a table name into 'Search tables...'.
- Click the chevron beside a table to see its columns.
- Click the '+' to drop the table into the query editor, then write the rest of the statement around it.
Note: the platform badges matter. A query naming a Windows-only table returns nothing from a macOS device, and the device is simply left out of the results.
