Admin Submissions by Grading verdict (FN-FP)

id: f7a36ec9-f708-420c-b248-7dfe6cc39d0a
name: Admin Submissions by Grading verdict (FN-FP)
description: |
  This query visualises the total amount of admin false negative or false positive submissions by the verdict of the submission grading.
description-detailed: |
  This query visualises the total amount of admin false negative or false positive submissions by the verdict of the submission grading.
  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:
  - CloudAppEvents
tactics:
  - InitialAccess
relevantTechniques:
  - T1566
query: |
  CloudAppEvents
  | where ActionType contains "AdminSubmissionTriage"
  | extend UserKey = (parse_json(RawEventData)).UserKey, SubmissionState = (parse_json(RawEventData)).SubmissionState,  SubmissionId=(parse_json(RawEventData)).SubmissionId, TriageVerdict=(parse_json(RawEventData)).GradingResult.TriageVerdict
  | summarize count() by tostring(TriageVerdict)
  | render piechart
version: 1.0.0