Phish Detections by Detection technology

id: c3a1fa22-8ccf-409e-80a5-78aa545bf77d
name: Phish Detections by Detection technology
description: |
  This query visualises total emails with Phish detections summarizing the data by various Phish detection technologies/controls
description-detailed: |
  This query visualises total emails with Phish detections summarizing the data by various Phish detection technologies/controls in Microsoft Defender for Office 365.
  The comment in the query excludes deliveries to the SecOps Mailbox and by the Phish Simulation system. Remove the "//" to apply the exclusion.
  Query is also included as part of the Defender for Office 365 solution in Sentinel: https://techcommunity.microsoft.com/blog/microsoftdefenderforoffice365blog/part-2-build-custom-email-security-reports-and-dashboards-with-workbooks-in-micr/4411303
requiredDataConnectors:
- connectorId: MicrosoftThreatProtection
  dataTypes:
  - EmailEvents
tactics:
  - InitialAccess
relevantTechniques:
  - T1566
query: |
  EmailEvents 
  //| where OrgLevelPolicy != "Phishing simulation" and OrgLevelPolicy != "SecOps Mailbox"
  | where ThreatTypes has 'Phish' 
  | project Timestamp, DT=parse_json(DetectionMethods) 
  | evaluate bag_unpack(DT) 
  | summarize count() by Phish=tostring(column_ifexists('Phish', ''))
  | sort by count_ desc
  | render piechart
version: 1.0.0