Lab Verified: 2026-11-15
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 descNeed to defang indicators or test triage logs?
Use our zero-telemetry client-side parser to extract, defang & format indicators.
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
DETECTION_ENGINEERING_FEEDBACK
Submit Feedback →Have tuning recommendations, encounter false positives in your environment, or want to contribute rule improvements?