ASimWebSessionLogs

ASimWebSessionLogs Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel The Advanced Security Information Model (ASIM) Web Session normalization schema - describe an IP network activity. For example, IP network activities are reported by web servers, web proxies, and web security gateways.

Table retention #

HotDays ColdDays TotalInteractiveDays
14 76 90

Schema #

Name Description Type
_BilledSize Double
_IsBillable String
_ResourceId A unique identifier for the resource that the record is associated with String
_SubscriptionId A unique identifier for the subscription that the record is associated with String
AdditionalFields Additional information, represented using key/value pairs provided by the source which do not map to ASim. Object
DstAppId The ID of the destination application, as reported by the reporting device. String
DstAppName The name of the destination application. String
DstAppType The type of the destination application. String
DstBytes The number of bytes sent from the destination to the source for the connection or session. If the event is aggregated, DstBytes is the sum over all aggregated sessions. Int64
DstDeviceType The type of the destination device. String
DstDomain The domain of the destination device. String
DstDomainType The type of DstDomain. String
DstDvcId The ID of the destination device. String
DstDvcIdType The type of DstDvcId. String
DstDvcScope The cloud platform scope the destination device belongs to. DvcScope maps to a subscription on Azure and to an account on AWS. String
DstDvcScopeId The cloud platform scope ID the destination device belongs to. DvcScopeId map to a subscription ID on Azure and to an account ID on AWS. String
DstFQDN The destination device hostname, including domain information when available. String
DstGeoCity The city associated with the destination IP address. String
DstGeoCountry The country associated with the destination IP address. String
DstGeoLatitude The latitude of the geographical coordinate associated with the destination IP address. Double
DstGeoLongitude The longitude of the geographical coordinate associated with the destination IP address. Double
DstGeoRegion The region, or state, within a country associated with the destination IP address. String
DstHostname The destination device hostname, excluding domain information. String
DstIpAddr The IP address of the connection or session destination. String
DstMacAddr The MAC address of the network interface used for the connection or session by the destination device. String
DstNatIpAddr The DstNatIpAddr represents either of: The original address of the destination device if network address translation was used or the IP address used by the intermediary device for communication with the source. String
DstNatPortNumber If reported by an intermediary NAT device, the port used by the NAT device for communication with the source. Int32
DstOriginalUserType The original destination user type, if provided by the source. String
DstPackets The number of packets sent from the destination to the source for the connection or session. The meaning of a packet is defined by the reporting device. If the event is aggregated, DstPackets is the sum over all aggregated sessions. Int64
DstPortNumber The destination IP port. Int32
DstUserId A machine-readable, alphanumeric, unique representation of the destination user. String
DstUserIdType The type of the ID stored in the DstUserId field. String
DstUsername The destination username, including domain information when available. Use the simple form only if domain information isn’t available. String
DstUsernameType Specifies the type of the username stored in the DstUsername field. String
DstUserType The type of destination user. String
Dvc A unique identifier of the device on which the event occurred or which reported the event. String
DvcAction The action taken on the web session. String
DvcDomain The domain of the device reporting the event. String
DvcDomainType The type of DvcDomain. Possible values include ‘Windows’ and ‘FQDN’. String
DvcFQDN The hostname of the device on which the event occurred or which reported the event. String
DvcHostname The hostname of the device reporting the event. String
DvcId The unique ID of the device on which the event occurred or which reported the event. String
DvcIdType The type of DvcId. String
DvcIpAddr The IP Address of the device reporting the event. String
DvcOriginalAction The original DvcAction as provided by the reporting device. String
EventCount This value is used when the source supports aggregation, and a single record may represent multiple events. Int32
EventEndTime The time 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. DateTime
EventMessage A general message or description. String
EventOriginalResultDetails The original result details provided by the source. This value is used to derive EventResultDetails, which should have only one of the values documented for each schema. String
EventOriginalSeverity The original severity as provided by the reporting device. This value is used to derive EventSeverity. String
EventOriginalSubType The original event subtype or ID, if provided by the source. For example, this field will be used to store the original Windows logon type. This value is used to derive EventSubType, which should have only one of the values documented for each schema. String
EventOriginalType The original event type or ID, if provided by the source. String
EventOriginalUid A unique ID of the original record, if provided by the source. String
EventOwner The owner of the event, which is usually the department or subsidiary in which it was generated. String
EventProduct The product generating the event. String
EventProductVersion The version of the product generating the event. String
EventReportUrl A URL provided in the event for a resource that provides more information about the event. String
EventResult 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. String
EventResultDetails The HTTP status code. String
EventSchemaVersion The version of the schema. String
EventSeverity The severity of the event. Valid values are: Informational, Low, Medium, or High. String
EventStartTime The time 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. DateTime
EventSubType Additional description of the event type, if applicable. String
EventType The operation reported by the record. String
EventVendor The vendor of the product generating the event. String
FileContentType For HTTP uploads, the content type of the uploaded file. String
FileMD5 For HTTP uploads, the MD5 hash of the uploaded file. String
FileName For HTTP uploads, the name of the uploaded file. String
FileSHA1 For HTTP uploads, the SHA1 hash of the uploaded file. String
FileSHA256 For HTTP uploads, the SHA256 hash of the uploaded file. String
FileSHA512 For HTTP uploads, the SHA512 hash of the uploaded file. String
FileSize For HTTP uploads, the size in bytes of the uploaded file. Int32
HttpContentFormat The content format part of the HttpContentType String
HttpContentType The HTTP Response content type header. String
HttpHost The virtual web server the HTTP request has targeted. String
HttpReferrer The HTTP referrer header. String
HttpRequestMethod The HTTP Method. String
HttpRequestTime The amount of time, in milliseconds, it took to send the request to the server. Int32
HttpRequestXff The HTTP X-Forwarded-For header. String
HttpResponseTime The amount of time, in milliseconds, it took to receive a response in the server. Int32
HttpUserAgent The HTTP user agent header. String
HttpVersion The HTTP Request Version. String
NetworkApplicationProtocol The application layer protocol used by the connection or session. String
NetworkBytes Number of bytes sent in both directions. If both BytesReceived and BytesSent exist, BytesTotal should equal their sum. If the event is aggregated, NetworkBytes is the sum over all aggregated sessions. Int64
NetworkConnectionHistory TCP flags and other potential IP header information. String
NetworkDirection The direction of the connection or session. String
NetworkDuration The amount of time, in milliseconds, for the completion of the web session or connection. Int32
NetworkIcmpCode For an ICMP message, the ICMP message type numeric value as described in RFC 2780 for IPv4 network connections, or in RFC 4443 for IPv6 network connections. Int32
NetworkIcmpType For an ICMP message, the ICMP message type text representation, as described in RFC 2780 for IPv4 network connections, or in RFC 4443 for IPv6 network connections. String
NetworkPackets The number of packets sent in both directions. If both PacketsReceived and PacketsSent exist, BytesTotal should equal their sum. The meaning of a packet is defined by the reporting device. If the event is aggregated, NetworkPackets is the sum over all aggregated sessions. Int64
NetworkProtocol The IP protocol used by the connection or session as listed in IANA protocol assignment, which is typically TCP, UDP, or ICMP. String
NetworkProtocolVersion The version of NetworkProtocol. String
NetworkSessionId The session identifier as reported by the reporting device. String
Rule Either NetworkRuleName or NetworkRuleNumber String
RuleName The name or ID of the rule by which DvcAction was decided upon. Example: AnyAnyDrop String
RuleNumber The number of the rule by which DvcAction was decided upon. Example: 23 Int32
SourceSystem String
SrcAppId The ID of the source application, as reported by the reporting device. String
SrcAppName The name of the source application. String
SrcAppType The type of the source application. String
SrcBytes The number of bytes sent from the source to the destination for the connection or session. If the event is aggregated, SrcBytes is the sum over all aggregated sessions. Int64
SrcDeviceType The type of the source device. String
SrcDomain The domain of the source device. String
SrcDomainType The type of SrcDomain. String
SrcDvcId The ID of the source device. String
SrcDvcIdType The type of SrcDvcId. String
SrcDvcScope The cloud platform scope the source device belongs to. DvcScope maps to a subscription on Azure and to an account on AWS. String
SrcDvcScopeId The cloud platform scope ID the source device belongs to. DvcScopeId map to a subscription ID on Azure and to an account ID on AWS. String
SrcFQDN The source device hostname, including domain information when available. String
SrcGeoCity The city associated with the source IP address. String
SrcGeoCountry The country associated with the source IP address. String
SrcGeoLatitude The latitude of the geographical coordinate associated with the source IP address. Double
SrcGeoLongitude The longitude of the geographical coordinate associated with the source IP address. Double
SrcGeoRegion The region within a country associated with the source IP address. String
SrcHostname The source device hostname, excluding domain information. If no device name is available, may store the relevant IP address. String
SrcIpAddr The IP address from which the connection or session originated. String
SrcMacAddr The MAC address of the network interface from which the connection or session originated. String
SrcNatIpAddr The SrcNatIpAddr represents either of: The original address of the source device if network address translation was used or the IP address used by the intermediary device for communication with the destination. String
SrcNatPortNumber If reported by an intermediary NAT device, the port used by the NAT device for communication with the destination. Int32
SrcOriginalUserType The original destination user type, if provided by the by the reporting device. String
SrcPackets The number of packets sent from the source to the destination for the connection or session. The meaning of a packet is defined by the reporting device. If the event is aggregated, SrcPackets is the sum over all aggregated sessions. Int64
SrcPortNumber The IP port from which the connection originated. Might not be relevant for a session comprising multiple connections. Int32
SrcProcessGuid A generated unique identifier (GUID) of the source process. String
SrcProcessId The process ID (PID) of the source process. String
SrcProcessName The name of the source process. String
SrcUserId A machine-readable, alphanumeric, unique representation of the source user. String
SrcUserIdType The type of the ID stored in the SrcUserId field. String
SrcUsername The source username, including domain information when available. String
SrcUsernameType Specifies the type of the username stored in the SrcUsername field. String
SrcUserScope The scope, such as Azure AD tenant, in which SrcUserId and SrcUsername are defined. String
SrcUserScopeId The ID of the scope, such as Azure AD tenant, in which SrcUserId and SrcUsername are defined. String
SrcUserType The type of the source user. String
TenantId String
ThreatCategory The category of the threat or malware identified in the web session. String
ThreatConfidence The confidence level of the threat identified, normalized to a value between 0 and a 100. Int32
ThreatField The field for which a threat was identified. The value is either SrcIpAddr, DstIpAddr, Domain, or DnsResponseName. String
ThreatFirstReportedTime The first time the IP address or domain were identified as a threat. DateTime
ThreatId The ID of the threat or malware identified in the web session. String
ThreatIpAddr An IP address for which a threat was identified. The field ThreatField contains the name of the field ThreatIpAddr represents. String
ThreatIsActive True ID the threat identified is considered an active threat. Boolean
ThreatLastReportedTime The last time the IP address or domain were identified as a threat. DateTime
ThreatName The name of the threat or malware identified in the web session. String
ThreatOriginalConfidence The original confidence level of the threat identified, as reported by the reporting device. String
ThreatOriginalRiskLevel The risk level as reported by the reporting device. String
ThreatRiskLevel The risk level associated with the session. The level is a number between 0 to 100. Int32
TimeGenerated The timestamp (UTC) reflecting the time in which the event was generated. DateTime
Type The name of the table String
Url The full HTTP request URL, including parameters. String
UrlCategory The defined grouping of a URL or the domain part of the URL. String
UrlOriginal The original value of the URL, when the URL was modified by the reporting device and both values are provided. String

Schema changes #

Date Action
2024-10-18 Table added to tracking