name: Suspicious SQLite3 LSQuarantine Behavior
id: e1997b2e-655f-4561-82fd-aeba8e1c1a86
version: 1
date: '2021-02-22'
author: Michael Haag, Splunk
status: experimental
type: TTP
description: The following analytic identifies the use of a SQLite3 querying the MacOS
  preferences to identify the original URL the pkg was downloaded from. This particular
  behavior is common with MacOS adware-malicious software. Upon triage, review other
  processes in parallel for suspicious activity. Identify any recent package installations.
data_source:
- Sysmon Event ID 1
search:
  selection1:
    CommandLine: '*LSQuarantine*'
    Image|endswith: sqlite3
  condition: selection1
how_to_implement: To successfully implement this search you need to be ingesting information
  on process that include the name of the process responsible for the changes from
  your endpoints into the `Endpoint` datamodel in the `Processes` node.
known_false_positives: Unknown.
references:
- https://redcanary.com/blog/clipping-silver-sparrows-wings/
- https://www.marcosantadev.com/manage-plist-files-plistbuddy/
tags:
  analytic_story:
  - Silver Sparrow
  asset_type: Endpoint
  confidence: 50
  impact: 50
  message: tbd
  mitre_attack_id:
  - T1074
  observable:
  - name: user
    type: User
    role:
    - Victim
  - name: dest
    type: Hostname
    role:
    - Victim
  product:
  - Splunk Enterprise
  - Splunk Enterprise Security
  - Splunk Cloud
  risk_score: 25
  security_domain: endpoint