Skip to main content

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 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
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

Read Attack Chain
DETECTION_ENGINEERING_FEEDBACK

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

Submit Feedback →