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