Name: recent_items
Retrieves the list of recent items opened in OSX by parsing the plist per user.: Identify recently accessed items. Useful for compromised hosts.

Query:

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';

Additional Query Info:
Version: 1.4.5
Platform: darwin
Interval: 86400

JSON:

{
  "queries": {
    "recent_items": {
      "query" : "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';",
      "interval" : "86400",
      "platform" : "darwin",
      "version": "1.4.5",
      "description" : "Retrieves the list of recent items opened in OSX by parsing the plist per user.",
      "value" : "Identify recently accessed items. Useful for compromised hosts."
    }
  }
}