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, software catalog Integrations
Docs Pricing
More
News Case studies Ask around Meetups Share your story
The handbook Get your license Schedule a demo
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

routes

click to open the table of contents
macOS logo Windows logo Linux logo

routes

The active route table for the host system.

Column Type Description
destination text Destination IP address
flags integer Flags to describe route
gateway text Route gateway
hopcount integer Max hops expected
Only available on Linux and macOS
interface text Route local interface
metric integer Cost of route. Lowest is preferred
mtu integer Maximum Transmission Unit for the route
netmask integer Netmask length
source text Route source
type text Type of route

Example

Identify static routes

SELECT destination, interface, type FROM routes WHERE type='static';
Edit page

Questions?

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