Files
splunk-security_content/detections/endpoint/sqlite_module_in_temp_folder.yml
2023-09-19 15:17:24 -07:00

63 lines
2.1 KiB
YAML

name: Sqlite Module In Temp Folder
id: 0f216a38-f45f-11eb-b09c-acde48001122
version: 1
date: '2021-08-03'
author: Teoderick Contreras, Splunk
status: production
type: TTP
description: This search is to detect a suspicious file creation of sqlite3.dll in
%temp% folder. This behavior was seen in IcedID malware where it download sqlite
module to parse browser database like for chrome or firefox to stole browser information
related to bank, credit card or credentials.
data_source:
- Sysmon Event ID 1
search: '`sysmon` EventCode=11 (TargetFilename = "*\\sqlite32.dll" OR TargetFilename
= "*\\sqlite64.dll") (TargetFilename = "*\\temp\\*")
| stats count min(_time) as
firstTime max(_time) as lastTime by dest signature signature_id process_name file_name file_path action process_guid| `security_content_ctime(firstTime)` | `security_content_ctime(lastTime)`
| `sqlite_module_in_temp_folder_filter`'
how_to_implement: To successfully implement this search, you need to be ingesting
logs with the process name, parent process, and command-line executions from your
endpoints. If you are using Sysmon, you must have at least version 6.0.4 of the
Sysmon TA.
known_false_positives: unknown
references:
- https://www.cisecurity.org/insights/white-papers/security-primer-icedid
tags:
analytic_story:
- IcedID
asset_type: Endpoint
confidence: 30
impact: 30
message: Process $process_name$ create a file $file_name$ in host $dest$
mitre_attack_id:
- T1005
observable:
- name: dest
type: Hostname
role:
- Victim
- name: process_name
type: Process
role:
- Attacker
product:
- Splunk Enterprise
- Splunk Enterprise Security
- Splunk Cloud
required_fields:
- _time
- process_name
- TargetFilename
- EventCode
- ProcessId
- Image
risk_score: 9
security_domain: endpoint
tests:
- name: True Positive Test
attack_data:
- data: https://media.githubusercontent.com/media/splunk/attack_data/master/datasets/malware/icedid/simulated_icedid/windows-sysmon.log
source: XmlWinEventLog:Microsoft-Windows-Sysmon/Operational
sourcetype: xmlwineventlog