Recent_items_macos

Retrieves the list of recent items opened in OSX by parsing the plist per user.

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 recent items opened in OSX by parsing the plist per user.
-- tags: postmortem
-- platform: darwin
select
  username,
  key,
  value
from
  plist p,
  (
    select
      *
    from
      users
    where
      directory like '/Users/%'
  ) u
where
  p.path = u.directory || '/Library/Preferences/com.apple.recentitems.plist';

tags: SStagSS

Reference

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