| _BilledSize |
|
Double |
| _IsBillable |
|
String |
| AdditionalFields |
Additional information about the entity or event. |
Object |
| AttachmentCount |
Number of attachments in the email. |
Int32 |
| AuthenticationDetails |
List of pass or fail verdicts by email authentication protocols like DMARC, DKIM, SPF or a combination of multiple authentication types (CompAuth). |
String |
| BulkComplaintLevel |
Threshold assigned to email from bulk mailers, a high bulk complaint level (BCL) means the email is more likely to generate complaints, and thus more likely to be spam. |
Int32 |
| ConfidenceLevel |
List of confidence levels of any spam or phishing verdicts. For spam, this column shows the spam confidence level (SCL), indicating if the email was skipped (-1), found to be not spam (0,1), found to be spam with moderate confidence (5,6), or found to be spam with high confidence (9). For phishing, this column displays whether the confidence level is “High” or “Low”. |
String |
| Connectors |
Custom instructions that define organizational mail flow and how the email was routed. |
String |
| DeliveryAction |
Action of the delivered email. |
String |
| DeliveryLocation |
Location of the delivered email: Inbox/Folder, On-premises/External, Junk, Quarantine, Failed, Dropped, Deleted items. |
String |
| DetectionMethods |
Delivery action of the email: Delivered, Junked, Blocked, or Replaced. |
String |
| EmailAction |
Final action taken on the email based on filter verdict, policies, and user actions: Move message to junk mail folder, Add X-header, Modify subject, Redirect message, Delete message, send to quarantine, No action taken, Bcc message. |
String |
| EmailActionPolicy |
Action policy that took effect: Antispam high-confidence, Antispam, Antispam bulk mail, Antispam phishing, Anti-phishing domain impersonation, Anti-phishing user impersonation, Anti-phishing spoof, Anti-phishing graph impersonation, Antimalware Safe Attachments, Enterprise Transport Rules (ETR). |
String |
| EmailActionPolicyGuid |
Unique identifier of the policy that took effect. |
String |
| EmailClusterId |
Identifier of the email cluster. Emails are clustered (grouped) based on heuristic analysis of their contents. |
Int64 |
| EmailDirection |
Email direction: Inbound, Outbound, Intra-org. |
String |
| EmailLanguage |
Detected language of the email content. |
String |
| InternetMessageId |
Public-facing identifier for the email that is set by the sending email system. |
String |
| LatestDeliveryAction |
Last known action attempted on an email by the service or by an admin through manual remediation. |
String |
| LatestDeliveryLocation |
Last known location of the email. |
String |
| NetworkMessageId |
Unique identifier for the email, generated by Office 365. |
String |
| OrgLevelAction |
Action taken on the email in response to matches to a policy defined at the organizational level. |
String |
| OrgLevelPolicy |
Organizational policy that triggered the action taken on the email. |
String |
| RecipientEmailAddress |
Recipient email address or email address of the recipient after distribution list expansion. |
String |
| RecipientObjectId |
Email recipient Azure AD identifier. |
String |
| ReportId |
Unique identifier for the event. |
String |
| SenderDisplayName |
Sender email address in the from header, which is visible to email recipients on their email clients. |
String |
| SenderFromAddress |
Sender domain in the from header, which is visible to email recipients on their email clients. |
String |
| SenderFromDomain |
Verdict from the email filtering stack on whether the email contains malware, phishing, or other threats. |
String |
| SenderIPv4 |
IPv4 address of the last detected mail server that relayed the message. |
String |
| SenderIPv6 |
IPv6 address of the last detected mail server that relayed the message. |
String |
| SenderMailFromAddress |
Sender email address in the MAIL from header, also known as the envelope sender or the Return-Path address. |
String |
| SenderMailFromDomain |
Sender domain in the MAIL from header, also known as the envelope sender or the Return-Path address. |
String |
| SenderObjectId |
Sender email address in the from header, which is visible to email recipients on their email clients. |
String |
| SourceSystem |
|
String |
| Subject |
Email subject field. |
String |
| TenantId |
|
String |
| ThreatNames |
Sender email address in the from header, which is visible to email recipients on their email clients. |
String |
| ThreatTypes |
Verdict from the email filtering stack on whether the email contains malware, phishing, or other threats. |
String |
| TimeGenerated |
Date and time (UTC) when the record was generated. |
DateTime |
| Timestamp |
Date and time when the record was generated |
DateTime |
| Type |
The name of the table |
String |
| UrlCount |
Number of embedded URLs in the email. |
Int32 |
| UserLevelAction |
Action taken on the email in response to matches to a mailbox policy defined by the recipient. |
String |
| UserLevelPolicy |
End user mailbox policy that triggered the action taken on the email. |
String |