Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Microsoft Sentinel normalized email event logs table.
Table attributes
| Attribute | Value |
|---|---|
| Resource types | - |
| Categories | - |
| Solutions | SecurityInsights |
| Basic table support | Yes |
| Auxiliary / Lake table support | Yes |
| DCR workspace transformation support | Yes |
| Ingestion API support | Yes |
| Sample Queries | - |
Columns
| Column | Type | Description |
|---|---|---|
| AdditionalEntities | dynamic | Additional entities associated with the event. |
| AdditionalFields | dynamic | Additional information, represented using key/value pairs provided by the source which do not map to ASim. |
| AttackRemediationSteps | string | The recommended actions to remediate the attack identified in the email. |
| AttackTactics | string | The MITRE ATT&CK tactics associated with the attack identified in the email. |
| AttackTechniques | string | The MITRE ATT&CK techniques associated with the attack identified in the email. |
| _BilledSize | real | The record size in bytes |
| Dst | string | A unique identifier of the destination of the email event. |
| DstIpAddr | string | The IP address of the destination mail server. |
| Dvc | string | A unique identifier of the device reporting the event. |
| DvcAction | string | For reporting security systems, the action taken by the system. |
| DvcDescription | string | A descriptive text associated with the device. |
| DvcDomain | string | The domain of the device reporting the event. |
| DvcDomainType | string | The type of DvcDomain. |
| DvcFQDN | string | The hostname of the device on which the event occurred or which reported the event. |
| DvcHostname | string | The hostname of the device reporting the event. |
| DvcId | string | The unique ID of the device on which the event occurred or which reported the event. |
| DvcIdType | string | The type of DvcId. |
| DvcInterface | string | The network interface on which data was captured. |
| DvcIpAddr | string | The IP Address of the device reporting the event. |
| DvcMacAddr | string | The MAC address of the device on which the event occurred or which reported the event. |
| DvcOriginalAction | string | The original DvcAction as provided by the reporting device. |
| DvcOs | string | The operating system running on the device on which the event occurred or which reported the event. |
| DvcOsVersion | string | The version of the operating system on the device on which the event occurred or which reported the event. |
| DvcScope | string | The cloud platform scope the device belongs to. DvcScope map to a subscription ID on Azure and to an account ID on AWS. |
| DvcScopeId | string | The cloud platform scope ID the device belongs to. DvcScopeId map to a subscription ID on Azure and to an account ID on AWS. |
| DvcZone | string | The network on which the event occurred or which reported the event. |
| EmailBCCRecipients | dynamic | The email addresses of the blind carbon copy (BCC) recipients. |
| EmailCCRecipients | dynamic | The email addresses of the carbon copy (CC) recipients. |
| EmailDeliveryLocation | string | The location to which the email was delivered, such as the inbox, junk folder, quarantine, or deleted items. |
| EmailDirection | string | The direction of the email, such as inbound, outbound, internal, or local. |
| EmailDkimDomain | string | The domain used to verify the email using DomainKeys Identified Mail (DKIM). |
| EmailDkimOriginalResult | string | The original DKIM verification result as reported by the source. |
| EmailDkimResult | string | The normalized DomainKeys Identified Mail (DKIM) verification result. |
| EmailDkimSignature | string | The DomainKeys Identified Mail (DKIM) signature included in the email. |
| EmailDmarcOriginalResult | string | The original DMARC verification result as reported by the source. |
| EmailDmarcOverride | string | The reason the Domain-based Message Authentication, Reporting, and Conformance (DMARC) result was overridden. |
| EmailDmarcPolicy | string | The Domain-based Message Authentication, Reporting, and Conformance (DMARC) policy applied to the email. |
| EmailDmarcResult | string | The normalized Domain-based Message Authentication, Reporting, and Conformance (DMARC) verification result. |
| EmailFileCount | int | The number of files attached to the email. |
| EmailFiles | dynamic | The files attached to the email, including available file metadata. |
| EmailFromAddress | string | The email address in the From header. |
| EmailFromDomain | string | The domain of the email address in the From header. |
| EmailLanguage | string | The detected language of the email content. |
| EmailMailFromAddress | string | The sender email address used in the SMTP envelope. |
| EmailMailFromDomain | string | The domain of the sender address used in the SMTP envelope. |
| EmailOriginalDeliveryLocation | string | The original email delivery location as reported by the source. |
| EmailProtocolName | string | The application-layer protocol used to transmit the email, such as SMTP, IMAP, or POP3. |
| EmailReplyToAddress | string | The email address in the Reply-To header. |
| EmailReplyToDomain | string | The domain of the email address in the Reply-To header. |
| EmailSizeBytes | long | The size of the email in bytes, including its headers and attachments. |
| EmailSpfOriginalResult | string | The original Sender Policy Framework (SPF) verification result as reported by the source. |
| EmailSpfResult | string | The normalized Sender Policy Framework (SPF) verification result. |
| EmailSubject | string | The subject of the email. |
| EmailToRecipients | dynamic | The email addresses of the primary recipients. |
| EmailUrlCount | int | The number of URLs found in the email. |
| EmailUrls | dynamic | The URLs found in the email body or attachments. |
| EventCount | int | The number of events described by the record. |
| EventEndTime | datetime | The time (UTC) in which the event ended. If the source supports aggregation and the record represents multiple events, the time that the last event was generated. If not provided by the source record, this field aliases the TimeGenerated field. |
| EventMessage | string | A general message or description. |
| EventOriginalResultDetails | string | The original result details provided by the source. |
| EventOriginalSeverity | string | The original severity as provided by the reporting device. |
| EventOriginalType | string | The original event type or ID, if provided by the source. |
| EventOriginalUid | string | A unique ID of the original record, if provided by the source. |
| EventOwner | string | The owner of the event, which is usually the department or subsidiary in which it was generated. |
| EventProduct | string | The product generating the event. |
| EventProductVersion | string | The version of the product generating the event. |
| EventReportUrl | string | A URL provided in the event for a resource that provides more information about the event. |
| EventResult | string | The outcome of the event, represented by one of the following values: Success, Partial, Failure, NA (Not Applicable). The value may not be provided directly by the sources, in which case it is derived from other event fields, for example, the EventResultDetails field. |
| EventResultDetails | string | Reason or details for the result reported in the EventResult field. |
| EventSchema | string | The schema to which the event is normalized. The value is EmailEvent. |
| EventSchemaVersion | string | The version of the schema. |
| EventSeverity | string | The severity of the event. Valid values are: Informational, Low, Medium, or High. |
| EventStartTime | datetime | The time (UTC) in which the event started. If the source supports aggregation and the record represents multiple events, the time that the first event was generated. If not provided by the source record, this field aliases the TimeGenerated field. |
| EventSubType | string | Describes a subdivision of the operation reported in the EventType field. |
| EventType | string | Describes the operation reported by the record |
| EventUid | string | A unique identifier assigned to the normalized email event. |
| EventVendor | string | The vendor of the product generating the event. |
| IndicatorAssociation | string | The relationship between the threat indicator and the email event. |
| IndicatorType | string | The type of threat indicator associated with the email event. |
| IpAddr | string | An alias of the SrcIpAddr field. |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| Rule | string | An alias of the RuleName field. |
| RuleDescription | string | The description of the rule associated with the inspection results. |
| RuleName | string | The name or ID of the rule associated with the inspection results. |
| RuleNumber | int | The number of the rule associated with the inspection results. |
| SourceSystem | string | The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics |
| Src | string | A unique identifier of the source of the email event. |
| SrcDescription | string | A descriptive text associated with the source device. |
| SrcDeviceType | string | The type of the source device. |
| SrcDomain | string | The domain of the source device. |
| SrcDomainType | string | The type of SrcDomain. |
| SrcDvcId | string | The ID of the source device. |
| SrcDvcIdType | string | The type of SrcDvcId. |
| SrcDvcScope | string | The cloud platform scope the source device belongs to. SrcDvcScope map to a subscription ID on Azure and to an account ID on AWS. |
| SrcDvcScopeId | string | The cloud platform scope ID the source device belongs to. SrcDvcScopeId map to a subscription ID on Azure and to an account ID on AWS. |
| SrcFQDN | string | The source device hostname, including domain information when available. |
| SrcGeoCity | string | The city associated with the source IP address. |
| SrcGeoCountry | string | The country associated with the source IP address. |
| SrcGeoLatitude | real | The latitude of the geographical coordinate associated with the source IP address. |
| SrcGeoLongitude | real | The longitude of the geographical coordinate associated with the source IP address. |
| SrcGeoRegion | string | The region within a country associated with the source IP address. |
| SrcHostname | string | The source device hostname, excluding domain information. |
| SrcIpAddr | string | The Source IP address from which the connection or session originated. |
| SrcIsp | string | The internet service provider associated with the source IP address. |
| SrcUserId | string | A machine-readable, alphanumeric, unique representation of the source user. |
| SrcUserIdType | string | The type of the identifier stored in the SrcUserId field. |
| SrcUserName | string | The source username, including domain information when available. |
| SrcUsernameType | string | The type of the username stored in the SrcUserName field. |
| SrcUserScope | string | The scope, such as an email domain or tenant, in which the source user is defined. |
| SrcUserScopeId | string | The identifier of the scope in which the source user is defined. |
| SrcUserUpn | string | The user principal name (UPN) of the source user. |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| TenantId | string | The Log Analytics workspace ID |
| ThreatCategory | string | The category of the threat or malware identified in audit activity. |
| ThreatConfidence | int | The confidence level of the threat identified, normalized to a value between 0 and a 100. |
| ThreatField | string | The field for which a threat was identified. |
| ThreatFirstReportedTime | datetime | The first time the IP address or domain were identified as a threat. |
| ThreatId | string | The ID of the threat or malware identified in the audit activity. |
| ThreatIpAddr | string | An IP address or Domain for which a threat was identified. |
| ThreatIsActive | bool | True if the threat identified is considered an active threat. |
| ThreatLastReportedTime | datetime | The last time the IP address or domain were identified as a threat. |
| ThreatName | string | The name of the threat or malware identified in the audit activity. |
| ThreatOriginalCategory | string | The threat category as originally reported by the source. |
| ThreatOriginalConfidence | string | The original confidence level of the threat identified, as reported by the reporting device. |
| ThreatOriginalRiskLevel | string | The risk level as reported by the reporting device. |
| ThreatRiskLevel | int | The risk level associated with the identified threat. The level should be a number between 0 and 100. |
| TimeGenerated | datetime | The timestamp (UTC) reflecting the time in which the event was generated. |
| Type | string | The name of the table |
| User | string | An alias of the SrcUserName field. |