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.

Extend Fleet

Extend Fleet

Integrate your favorite tools with Fleet.

Customers A small chevron
Stripe + Fleet

Stripe + Fleet

Stripe moved 10,000 Macs to Fleet, saving hundreds of thousands annually

Foursquare + Fleet

Foursquare + Fleet

Foursquare cut costs and gained 114% ROI with Fleet

Faire + Fleet

Faire + Fleet

Faire secures Macs with CIS benchmarks and Fleet

What people are saying

What people are saying

Stories from the Fleet community.

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

file_lines

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

file​_lines

Allows reading an arbitrary file. Each line of the file is returned as a separate row.

Column Type Description
line text Output of the file, line by line.
path text Path of the file to read.
Required in WHERE clause

Example

Output the content of /etc/hosts line by line. 

SELECT * FROM file_lines WHERE path='/etc/hosts';

Notes

See also file_contents for reading the entire contents of a file as a single row. This table is from the Mac Admins osquery extension.

Edit page

Questions?

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