ASimNetworkSessionLogs

ASimNetworkSessionLogs Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel The Microsoft Sentinel network session normalization schema represents an IP network activity, such as network connections and network sessions. Such events are reported, for example, by operating systems, routers, firewalls, and intrusion prevention systems.

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
DstDescription A descriptive text associated with the destination. String
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
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
DstInterfaceGuid The GUID of the network interface used on the destination device. String
DstInterfaceName The network interface used for the connection or session by the destination device. 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
DstSubscriptionId The cloud platform subscription ID the destination device belongs to. DstSubscriptionId map to a subscription ID on Azure and to an account ID on AWS. String
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
DstVlanId The VLAN ID related to the destination device. String
DstZone The network zone of the destination, as defined by the reporting device. 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 network session. String
DvcDescription A descriptive text associated with the device. For example: Primary Domain Controller. 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
DvcInboundInterface If reported by an intermediary device, the network interface used by the NAT device for the connection to the source device. String
DvcInterface The network interface on which data was captured. This field is typically relevant to network related activity which is captured by an intermediate or tap device. String
DvcIpAddr The IP Address of the device reporting the event. String
DvcMacAddr The MAC address of the device on which the event occurred or which reported the event. Example: 00:1B:44:11:3A:B7 String
DvcOriginalAction The original DvcAction as provided by the reporting device. String
DvcOs The operating system running on the device reporting the event. String
DvcOsVersion The version of the operating system on the device reporting the event. String
DvcOutboundInterface If reported by an intermediary device, the network interface used by the NAT device for the connection to the destination device. String
DvcSubscriptionId The cloud platform subscription ID the device belongs to. DvcSubscriptionId map to a subscription ID on Azure and to an account ID on AWS. String
DvcZone The network on which the event occurred or which reported the event. The zone is defined 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
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 Reason or details for the result reported in the EventResult field. 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
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 network 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
NetworkRuleName The name or ID of the rule by which DvcAction was decided upon. String
NetworkRuleNumber The number of the rule by which DvcAction was decided upon. Int32
NetworkSessionId The session identifier as reported by the reporting device. String
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
SrcDescription A descriptive text associated with the source. String
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
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
SrcInterfaceGuid The GUID of the network interface used on the source device. String
SrcInterfaceName The network interface used for the connection or session by the source device. 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
SrcSubscriptionId The cloud platform subscription ID the source device belongs to. SrcSubscriptionId map to a subscription ID on Azure and to an account ID on AWS. 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
SrcUserType The type of the source user. String
SrcVlanId The VLAN ID related to the source device. String
SrcZone The network zone of the source, as defined by the reporting device. String
TcpFlagsAck The TCP ACK flag reported. The acknowledgment flag is used to acknowledge the successful receipt of a packet. As we can see from the diagram above, the receiver sends an ACK as well as a SYN in the second step of the three way handshake process to tell the sender that it received its initial packet. Boolean
TcpFlagsFin The TCP FIN flag reported. The finished flag means there is no more data from the sender. Therefore, it is used in the last packet sent from the sender. Boolean
TcpFlagsPsh The TCP PSH flag reported. The push flag is somewhat similar to the URG flag and tells the receiver to process these packets as they are received instead of buffering them. Boolean
TcpFlagsRst The TCP RST flag reported. The reset flag gets sent from the receiver to the sender when a packet is sent to a particular host that was not expecting it. Boolean
TcpFlagsSyn The TCP SYN flag reported. The synchronisation flag is used as a first step in establishing a three way handshake between two hosts. Only the first packet from both the sender and receiver should have this flag set. Boolean
TcpFlagsUrg The TCP URG flag reported. The urgent flag is used to notify the receiver to process the urgent packets before processing all other packets. The receiver will be notified when all known urgent data has been received. See RFC 6093 for more details. Boolean
TenantId String
ThreatCategory The category of the threat or malware identified in the network 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 network 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 network 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

Schema changes #

Date Action
2024-10-18 Table added to tracking