Shell_history

osquery
Retrieves the command history, per user, by parsing the shell history files.
Author

Chainguard

Published

January 29, 2025

Description

ODK (osquery-defense-kit) is unique in that the queries are designed to be used as part of a production detection & response pipeline. The detection queries are formulated to return zero rows during normal expected behavior, so that they may be configured to generate alerts when rows are returned.

Query

-- Retrieves the command history, per user, by parsing the shell history files.
--
-- tags: postmortem
-- platform: posix
SELECT
  *
FROM
  users
  JOIN shell_history USING (uid);

tags: SStagSS

Reference

https://github.com/chainguard-dev/osquery-defense-kit