Top accounts performing user submissions (FP)

id: fa0ce1b0-59fa-4fea-87e8-6752951cec3f
name: Top accounts performing user submissions (FP)
description: |
  This query visualises the top accounts performing user false positive submissions.
description-detailed: |
  This query visualises the top accounts performing user false positive submissions.
  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 == "UserSubmission"
  | extend RawData = parse_json(RawEventData)
  | extend RecordType = toint(RawData.RecordType), SubmissionType = tostring(RawData.SubmissionType), UserId = tostring(RawData.UserId)
  | where RecordType == 29 and SubmissionType == "3"
  | summarize count() by UserId
  | top 15 by count_
  | render piechart
version: 1.0.0