Logged_in_users

Retrieves the list of all the currently logged in users in the target system.

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 list of all the currently logged in users in the target system.
--
-- tags: postmortem
-- platform: posix
SELECT
  liu.*,
  p.name,
  p.cmdline,
  p.cwd,
  p.start_time,
  p.root
FROM
  logged_in_users liu,
  processes p
WHERE
  liu.pid = p.pid;

tags: SStagSS

Reference

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