splunk-security_content/docs/_posts/2021-02-22-suspicious_sqlite3_lsquarantine_behavior.md

title, excerpt, categories, last_modified_at, toc, toc_label, tags

title	excerpt	categories	last_modified_at	toc	toc_label	tags
Suspicious SQLite3 LSQuarantine Behavior	Data Staged	Endpoint	2021-02-22	true		Data Staged Collection Splunk Enterprise Splunk Enterprise Security Splunk Cloud Endpoint

⚠️ WARNING THIS IS A EXPERIMENTAL DETECTION

We have not been able to test, simulate, or build datasets for this detection. Use at your own risk. This analytic is NOT supported.

Try in Splunk Security Cloud{: .btn .btn--success}

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.

• Type: TTP
• Product: Splunk Enterprise, Splunk Enterprise Security, Splunk Cloud
• Datamodel: Endpoint
• Last Updated: 2021-02-22
• Author: Michael Haag, Splunk
• ID: e1997b2e-655f-4561-82fd-aeba8e1c1a86

ATT&CK

ID	Technique	Tactic
T1074	Data Staged	Collection

Search

| tstats `security_content_summariesonly` count min(_time) as firstTime max(_time) as lastTime from datamodel=Endpoint.Processes where Processes.process_name=sqlite3 Processes.process=*LSQuarantine* by Processes.dest Processes.user Processes.parent_process Processes.process_name Processes.process Processes.process_id Processes.parent_process_id 
| `drop_dm_object_name(Processes)` 
| `security_content_ctime(firstTime)`
| `security_content_ctime(lastTime)` 
| `suspicious_sqlite3_lsquarantine_behavior_filter`

Associated Analytic Story

• Silver Sparrow

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.

Required field

• _time
• Processes.process_name
• Processes.process
• Processes.dest
• Processes.user
• Processes.parent_process
• Processes.process_id
• Processes.parent_process_id

Kill Chain Phase

• Actions on Objectives

Known False Positives

Unknown.

Reference

• https://redcanary.com/blog/clipping-silver-sparrows-wings/
• https://marcosantadev.com/manage-plist-files-plistbuddy/

Test Dataset

Replay any dataset to Splunk Enterprise by using our replay.py tool or the UI. Alternatively you can replay a dataset into a Splunk Attack Range

source | version: 1