Lab Verified: 2026-09-22
Sweden Fines Miljödata $183K Over 2.2M Citizen Data Breach Hunt Query
The regulatory probe found systemic GDPR Article 32 violations, citing failure to verify software integrity during installation and absent real-time intrusion monitoring.
// Microsoft Sentinel / Defender Hunting Query: Detect Unmonitored Mass Data Staging and Unauthorized Archive Creation
DeviceProcessEvents
| where Timestamp > ago(7d)
| where FileName in~ ("7z.exe", "rar.exe", "bcp.exe", "sqlcmd.exe", "powershell.exe")
| where ProcessCommandLine has_any (
"*.sql",
"*.bak",
"queryout",
"personnummer",
"Miljodata",
"Export-Csv",
"-p",
"Out-File"
)
| where InitiatingProcessFileName !in~ ("MonitoringAgent.exe", "BackupService.exe", "sqlservr.exe")
| project Timestamp, DeviceName, InitiatingProcessFileName, FileName, ProcessCommandLine, AccountName, DeviceId
| sort by Timestamp descNeed to defang indicators or test triage logs?
Use our zero-telemetry client-side parser to extract, defang & format indicators.
Target Log Sources & Tables
DeviceProcessEvents
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
Sweden Fines Miljödata $183K Over 2.2M Citizen Data Breach
Disclosed: 2026-09-22
DETECTION_ENGINEERING_FEEDBACK
Submit Feedback →Have tuning recommendations, encounter false positives in your environment, or want to contribute rule improvements?