User Email Submission Trend (FP)

id: 98ed7471-ce5e-4d48-b9f9-dae4cf045b3e
name: User Email Submission Trend (FP)
description: |
  This query visualises the daily amount of user false positive email submissions over time.
description-detailed: |
  This query visualises the daily amount of user false positive email submissions over time.
  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: |
  let TimeStart = startofday(ago(30d));
  let TimeEnd = startofday(now());
  CloudAppEvents
  | where Timestamp >= TimeStart and Timestamp < TimeEnd
  | where ActionType == "UserSubmission"
  | extend RawData = parse_json(RawEventData)
  | where tostring(RawData.SubmissionType) == "3" and tostring(RawData.SubmissionContentType) == "Mail"
  | make-series Count = count() default = 0 on Timestamp from TimeStart to TimeEnd step 1d
  | extend Details = "User_Email_FP"
  | project Count, Details, Timestamp
  | render timechart
version: 1.0.0