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

Infrastructure as code

See every change, undo 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

shell_history

click to open the table of contents
macOS logo Linux logo

shell​_history

A line-delimited (command) table of per-user .*_history data.

Column Type Description
command text Unparsed date/line/command history line
history_file text Path to the .*_history for this user
time integer Entry timestamp. It could be absent, default value is 0.
uid bigint Shell history owner

Example

SELECT * FROM users CROSS JOIN shell_history USING (uid);

See command line executions and related timestamps. Useful for threat hunting when a device is suspected of being compromised.

SELECT u.username, s.command, s.time FROM users u CROSS JOIN shell_history s USING (uid);

Notes

  • Querying this table requires joining against the users table. Learn more
Edit page

Questions?

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