Skip to main content

TSMC Data Breach Hunt Query

Root cause vector: Supply chain breach targeting third-party cloud database hosting 46,000 employee profiles, national IDs, and banking data.

// Microsoft Sentinel / Defender for Cloud Apps Hunting Query
// Identifies anomalous bulk data export or high-volume download events initiated by external vendor service accounts
CloudAppEvents
| where Timestamp >= ago(14d)
| where ActionType in~ ("FileDownloaded", "DataExported", "BulkDownloadInitiated", "SharePointFileOperation")
| where RawEventData has_any ("employee", "personnel", "hr_export", "payroll", "staff_id")
| extend DownloadSizeMB = toreal(parse_json(RawEventData).FileSize) / 1048576
| where DownloadSizeMB > 500 or parse_json(RawEventData).TotalCount > 1000
| summarize 
    TotalDownloadedMB = sum(DownloadSizeMB),
    EventCount = count(),
    UniqueFiles = dcount(tostring(parse_json(RawEventData).FileName))
    by AccountDisplayName, AccountId, IPAddress, ISP, CountryCode, bin(Timestamp, 1h)
| where TotalDownloadedMB > 1000 or EventCount > 500
| order by TotalDownloadedMB desc
Need to defang indicators or test triage logs?
Use our zero-telemetry client-side parser to extract, defang & format indicators.
Open SOC Defanger Workbench
Target Log Sources & Tables
CloudAppEvents

Ensure telemetry connector is actively ingesting this table into your Sentinel workspace or Defender XDR.

False Positives & Tuning Guidance

Legitimate administrative software deployment scripts, authorized security testing, or system maintenance tasks.

Source Incident Analysis

TSMC Data Breach: Hacker Leaks 46,000 Records via Cloud Vendor

Disclosed: 2026-11-15

Read Attack Chain
DETECTION_ENGINEERING_FEEDBACK

Have tuning recommendations, encounter false positives in your environment, or want to contribute rule improvements?

Submit Feedback →