Detection: Office Document Creating Schedule Task

Updated Date: 2024-09-30 ID: cc8b7b74-9d0f-11eb-8342-acde48001122 Author: Teoderick Contreras, Splunk Type: TTP Product: Splunk Enterprise Security

Description

The following analytic detects an Office document creating a scheduled task, either through a macro VBA API or by loading taskschd.dll. This detection leverages Sysmon EventCode 7 to identify when Office applications load the taskschd.dll file. This activity is significant as it is a common technique used by malicious macro malware to establish persistence or initiate beaconing. If confirmed malicious, this could allow an attacker to maintain persistence, execute arbitrary commands, or schedule future malicious activities, posing a significant threat to the environment.

Search

1`sysmon` EventCode=7 process_name IN ("WINWORD.EXE", "EXCEL.EXE", "POWERPNT.EXE","onenote.exe","onenotem.exe","onenoteviewer.exe","onenoteim.exe", "msaccess.exe") loaded_file_path = "*\\taskschd.dll" 
2| stats min(_time) as firstTime max(_time) as lastTime count by user_id, dest, process_name,loaded_file, loaded_file_path, original_file_name, process_guid 
3| `security_content_ctime(firstTime)` 
4| `security_content_ctime(lastTime)` 
5| `office_document_creating_schedule_task_filter`

Data Source

Name	Platform	Sourcetype	Source
Sysmon EventID 7	Windows	`'xmlwineventlog'`	`'XmlWinEventLog:Microsoft-Windows-Sysmon/Operational'`

Macros Used

Name	Value
security_content_ctime	`convert timeformat="%Y-%m-%dT%H:%M:%S" ctime($field$)`
office_document_creating_schedule_task_filter	`search *`

office_document_creating_schedule_task_filter is an empty macro by default. It allows the user to filter out any results (false positives) without editing the SPL.

Annotations

- MITRE ATT&CK

+ Kill Chain Phases

+ NIST

+ CIS

- Threat Actors

ID	Technique	Tactic
T1566	Phishing	Initial Access
T1566.001	Spearphishing Attachment	Initial Access

KillChainPhase.DELIVERY

NistCategory.DE_CM

Cis18Value.CIS_10

Axiom

GOLD SOUTHFIELD

INC Ransom

APT-C-36

APT1

APT12

APT19

APT28

APT29

APT30

APT32

APT33

APT37

APT38

APT39

APT41

Ajax Security Team

Andariel

BITTER

BRONZE BUTLER

BlackTech

CURIUM

Cobalt Group

Confucius

DarkHydrus

Darkhotel

Dragonfly

EXOTIC LILY

Elderwood

FIN4

FIN6

FIN7

FIN8

Ferocious Kitten

Gallmaker

Gamaredon Group

Gorgon Group

Higaisa

Inception

IndigoZebra

Kimsuky

Lazarus Group

LazyScripter

Leviathan

Machete

Malteiro

Mofang

Molerats

Moonstone Sleet

MuddyWater

Mustang Panda

Naikon

Nomadic Octopus

OilRig

PLATINUM

Patchwork

RTM

Rancor

RedCurl

Saint Bear

Sandworm Team

SideCopy

Sidewinder

Silence

Star Blizzard

TA2541

TA459

TA505

TA551

The White Company

Threat Group-3390

Tonto Team

Transparent Tribe

Tropic Trooper

WIRTE

Windshift

Winter Vivern

Wizard Spider

admin@338

menuPass

Default Configuration

This detection is configured by default in Splunk Enterprise Security to run with the following settings:

Setting	Value
Disabled	true
Cron Schedule	`0 * * * *`
Earliest Time	`-70m@m`
Latest Time	`-10m@m`
Schedule Window	`auto`
Creates Notable	Yes
Rule Title	`%name%`
Rule Description	`%description%`
Notable Event Fields	user, dest
Creates Risk Event	True

This configuration file applies to all detections of type TTP. These detections will use Risk Based Alerting and generate Notable Events.

Implementation

To successfully implement this search, you need to be ingesting logs with the process name and ImageLoaded (Like sysmon EventCode 7) from your endpoints. If you are using Sysmon, you must have at least version 6.0.4 of the Sysmon TA. Also be sure to include those monitored dll to your own sysmon config.

Known False Positives

False positives may occur if legitimate office documents are creating scheduled tasks. Ensure to investigate the scheduled task and the command to be executed. If the task is benign, add the task name to the exclusion list. Some applications may legitimately load taskschd.dll.

Associated Analytic Story

Spearphishing Attachments

Risk Based Analytics (RBA)

Risk Message	Risk Score	Impact	Confidence
An Office document was identified creating a scheduled task on $dest$. Investigate further.	49	70	70

The Risk Score is calculated by the following formula: Risk Score = (Impact * Confidence/100). Initial Confidence and Impact is set by the analytic author.

References

Detection Testing

Test Type	Status	Dataset	Source	Sourcetype
Validation	✅ Passing	N/A	N/A	N/A
Unit	✅ Passing	Dataset	`XmlWinEventLog:Microsoft-Windows-Sysmon/Operational`	`XmlWinEventLog`
Integration	✅ Passing	Dataset	`XmlWinEventLog:Microsoft-Windows-Sysmon/Operational`	`XmlWinEventLog`

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: GitHub | Version: 8