Detect Local Email Collection in IBM QRadar
Adversaries may target user email on local systems to collect sensitive information. Outlook stores email data in offline data files (.ost) and personal storage table files (.pst), typically located in C:\Users\<username>\AppData\Local\Microsoft\Outlook or C:\Users\<username>\Documents\Outlook Files. Threat actors access, copy, or exfiltrate these files to harvest credentials, reconnaissance data, business intelligence, or email threads for thread-hijacking phishing campaigns. Groups such as APT1, QakBot, Carbanak, and RedCurl have all employed this technique at scale.
MITRE ATT&CK
- Tactic
- Collection
- Technique
- T1114 Email Collection
- Sub-technique
- T1114.001 Local Email Collection
- Canonical reference
- https://attack.mitre.org/techniques/T1114/001/
QRadar Detection Query
SELECT
DATEFORMAT(devicetime, 'yyyy-MM-dd HH:mm:ss') AS event_time,
logsourcename(logsourceid) AS log_source,
"username",
"sourceip",
QIDNAME(qid) AS event_name,
"EventID",
"TargetFilename",
"Image" AS process_image,
"ParentImage" AS parent_image,
"CommandLine" AS command_line,
CASE
WHEN "EventID" = '11'
AND (LOWER(COALESCE("TargetFilename", '')) LIKE '%appdata\\local\\microsoft\\outlook%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%documents\\outlook files%')
AND LOWER(COALESCE("Image", '')) NOT SIMILAR TO '%(outlook|searchindexer|searchprotocolhost|msosync|ocpubmgr)\.exe'
THEN 'NonOutlookProcessAccessingEmailStore'
WHEN "EventID" = '11'
AND (LOWER(COALESCE("TargetFilename", '')) NOT LIKE '%appdata\\local\\microsoft\\outlook%'
AND LOWER(COALESCE("TargetFilename", '')) NOT LIKE '%documents\\outlook files%')
AND (LOWER(COALESCE("TargetFilename", '')) LIKE '%windows\\temp%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\temp\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\downloads\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\public\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\programdata\\%')
THEN 'EmailFileStagedInSuspiciousLocation'
WHEN "EventID" = '1'
AND (LOWER(COALESCE("CommandLine", '')) LIKE '%.pst%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%.ost%')
AND (LOWER(COALESCE("CommandLine", '')) LIKE '%xcopy%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%robocopy%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%compress-archive%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%invoke-webrequest%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '% copy %'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%wmic%')
THEN 'CommandLinePstCopyOperation'
WHEN "EventID" = '1'
AND (LOWER(COALESCE("CommandLine", '')) LIKE '%.pst%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%.ost%')
THEN 'CommandLineReferencingEmailStore'
ELSE NULL
END AS detection_branch,
CASE
WHEN (LOWER(COALESCE("TargetFilename", '')) LIKE '%windows\\temp%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\downloads\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\public\\%')
AND LOWER(COALESCE("Image", '')) NOT SIMILAR TO '%(outlook|searchindexer|searchprotocolhost|msosync|ocpubmgr)\.exe'
THEN 3
WHEN (LOWER(COALESCE("CommandLine", '')) LIKE '%xcopy%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%robocopy%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%compress-archive%')
AND (LOWER(COALESCE("CommandLine", '')) LIKE '%.pst%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%.ost%')
THEN 3
WHEN LOWER(COALESCE("Image", '')) NOT SIMILAR TO '%(outlook|searchindexer|searchprotocolhost|msosync|ocpubmgr)\.exe'
AND (LOWER(COALESCE("TargetFilename", '')) LIKE '%.pst'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%.ost')
THEN 2
ELSE 1
END AS risk_score
FROM events
WHERE
LOGSOURCETYPEID(logsourceid) IN (413 /* Sysmon */, 12 /* Windows Security */)
AND devicetime > NOW() - 1 DAYS
AND (
(
"EventID" IN ('11')
AND (
LOWER(COALESCE("TargetFilename", '')) LIKE '%.pst'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%.ost'
)
)
OR (
"EventID" IN ('1')
AND LOWER(COALESCE("Image", '')) SIMILAR TO '%(cmd|powershell|pwsh|xcopy|robocopy|wmic|forfiles)\.exe'
AND (
LOWER(COALESCE("CommandLine", '')) LIKE '%.pst%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%.ost%'
)
)
)
AND CASE
WHEN "EventID" = '11'
AND (LOWER(COALESCE("TargetFilename", '')) LIKE '%appdata\\local\\microsoft\\outlook%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%documents\\outlook files%')
AND LOWER(COALESCE("Image", '')) NOT SIMILAR TO '%(outlook|searchindexer|searchprotocolhost|msosync|ocpubmgr)\.exe'
THEN TRUE
WHEN "EventID" = '11'
AND (LOWER(COALESCE("TargetFilename", '')) NOT LIKE '%appdata\\local\\microsoft\\outlook%')
AND (LOWER(COALESCE("TargetFilename", '')) LIKE '%\\temp\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\downloads\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\public\\%'
OR LOWER(COALESCE("TargetFilename", '')) LIKE '%\\programdata\\%')
THEN TRUE
WHEN "EventID" = '1'
AND (LOWER(COALESCE("CommandLine", '')) LIKE '%.pst%'
OR LOWER(COALESCE("CommandLine", '')) LIKE '%.ost%')
THEN TRUE
ELSE FALSE
END = TRUE
ORDER BY risk_score DESC, devicetime DESC AQL query for IBM QRadar detecting local Outlook PST/OST email collection via Sysmon events. Monitors Sysmon Event ID 11 (file creation) for PST/OST files accessed by non-Outlook processes or staged outside normal Outlook directories, and Sysmon Event ID 1 (process creation) for command-line operations referencing PST/OST files with copy/exfiltration verbs.
Data Sources
Required Tables
False Positives & Tuning
- Enterprise backup agents (Commvault, NetBackup, Veeam) generating Sysmon Event ID 11 for PST/OST files during scheduled backup windows — add known backup service account names and process names to a reference set for exclusion
- PST-to-cloud migration utilities during Office 365 onboarding (e.g., Microsoft MFCMAPI, BitTitan MigrationWiz agent) copying PST files to staging directories — correlate with active migration project CIs
- Security or compliance scanning tools (e.g., Varonis, Spirion) that enumerate or read email files during data classification scans — verify against approved scanner schedule and service account
Other platforms for T1114.001
Testing Methodology
Validate this detection against 4 adversary techniques from Atomic Red Team. Each test below lists the behaviour to exercise and the telemetry you should expect to see. Executable commands and cleanup steps are available with Pro.
- Test 1Copy Outlook OST File to Windows Temp (cmd.exe)
Expected signal: Sysmon Event ID 1: Process Create with Image=cmd.exe, CommandLine containing '.ost' and 'copy'. Sysmon Event ID 11: File Create with TargetFilename=%TEMP%\staged_email.ost, Image=cmd.exe. Security Event ID 4688 (if process command line auditing enabled) with same details. Security Event ID 4663 (if object access auditing enabled on Outlook directory) showing read access by cmd.exe.
- Test 2Enumerate and Copy PST Files with PowerShell
Expected signal: Sysmon Event ID 1: Process Create with Image=powershell.exe, CommandLine containing 'Get-ChildItem', '.pst', and 'Copy-Item'. Sysmon Event ID 11: File Create with TargetFilename=C:\ProgramData\dftest_email_staged.pst, Image=powershell.exe. PowerShell ScriptBlock Log Event ID 4104 capturing full script. Security Event ID 4688 for the PowerShell process.
- Test 3WMIC Remote Process PST Copy (Chimera APT Pattern)
Expected signal: Sysmon Event ID 1: Process Create with Image=wmic.exe, CommandLine containing 'process call create' and '.ost'. Secondary Sysmon Event ID 1 for the spawned cmd.exe with the copy command. Sysmon Event ID 11 for the created file in Temp. Security Event ID 4688 for both wmic.exe and cmd.exe child process. Sysmon Event ID 3 (Network Connection) for wmic WMI connection to localhost.
- Test 4Archive Outlook Data Files for Exfiltration Preparation
Expected signal: Sysmon Event ID 1: Process Create with Image=powershell.exe, CommandLine containing 'Compress-Archive' and '.pst'. Sysmon Event ID 11: File Create events for both the dummy .pst and the resulting .zip archive in Temp. PowerShell ScriptBlock Log Event ID 4104 with full script. File Create event for the archive file may also trigger DLP rules if archive-in-staging detection is enabled.
References (9)
- https://attack.mitre.org/techniques/T1114/001/
- https://support.office.com/en-us/article/introduction-to-outlook-data-files-pst-and-ost-222eaf92-a995-45d9-bde2-f331f60e2790
- https://practical365.com/clients/office-365-proplus/outlook-cached-mode-ost-file-sizes/
- https://www.mandiant.com/resources/blog/apt1-exposing-one-of-chinas-cyber-espionage-units
- https://blog.talosintelligence.com/2018/07/smoking-guns-smoke-loader-learned-new.html
- https://www.kroll.com/en/insights/publications/cyber/qakbot-malware-growing-threat
- https://www.group-ib.com/resources/threat-research/red-curl.html
- https://learn.microsoft.com/en-us/defender-endpoint/advanced-hunting-devicefileevents-table
- https://github.com/redcanaryco/atomic-red-team/blob/master/atomics/T1114.001/T1114.001.md
Unlock Pro Content
Get the full detection package for T1114.001 including response playbook, investigation guide, and atomic red team tests.