Loginwindow3.Sql

Retrieves all the values for the loginwindow process in the target OSX 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 all the values for the loginwindow process in the target OSX system.
--
--
-- tags: postmortem
-- platform: darwin
select
  username,
  key,
  subkey,
  value
from
  plist p,
  (
    select
      *
    from
      users
    where
      directory like '/Users/%'
  ) u
where
  p.path = u.directory || '/Library/Preferences/com.apple.loginwindow.plist';

tags: SStagSS

Reference

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