ASimDnsActivityLogs

ASimDnsActivityLogs Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel The ASim DNS activity schema represents DNS protocol activity, which may be logged either by a DNS server or by a device sending DNS requests to a DNS server. The DNS protocol activity includes DNS queries, DNS server updates, and DNS bulk data transfers. Since the schema represents protocol activity, it is governed by RFCs and officially assigned parameter lists. The DNS activity schema does not represent DNS server audit events.

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
DnsFlags The DNS request flags, as provided by the reporting device. The structure of the DNS flags information may vary between different reporting devices. String
DnsFlagsAuthenticated The DNS authenticated answer flag, which is related to DNSSEC, indicates in a response that all data included in the answer and authority sections of the response have been verified by the server according to the policies of that server. see RFC 3655 Section 6.1 for more information. Boolean
DnsFlagsAuthoritative The DNS authoritative answer flag indicates whether the response from the server was authoritative. Boolean
DnsFlagsCheckingDisabled The DNS CD flag, which is related to DNSSEC, indicates in a query that non-verified data is acceptable to the system sending the query. Boolean
DnsFlagsRecursionAvailable The DNS RA flag indicates in a response that that server supports recursive queries. Boolean
DnsFlagsRecursionDesired The DNS recursion desired flag indicates in a request that that client would like the server to use recursive queries. Boolean
DnsFlagsTruncated The DNS TC flag indicates that a response was truncates as it exceeded the maximum response size. Boolean
DnsFlagsZ The DNS Z flag is a deprecated DNS flag, which might be reported by older DNS systems. Boolean
DnsNetworkDuration The amount of time, in milliseconds, for the completion of DNS request. Int32
DnsQuery The domain that needs to be resolved. String
DnsQueryClass The DNS class ID as defined by the Internet Assigned Numbers Authority (IANA). Int32
DnsQueryClassName The DNS class name as defined by the Internet Assigned Numbers Authority (IANA). String
DnsQueryType The DNS resource record type codes as defined by the Internet Assigned Numbers Authority (IANA). Int32
DnsQueryTypeName The DNS resource record type name as defined by the Internet Assigned Numbers Authority (IANA). String
DnsResponseCode The DNS numerical response code as defined by the Internet Assigned Numbers Authority (IANA). Int32
DnsResponseIpCity The city associated with the response IP address. String
DnsResponseIpCountry The country associated with the response IP address. String
DnsResponseIpLatitude The Latitude of the geographical coordinate associated with the response IP address. Double
DnsResponseIpLongitude The longitude of the geographical coordinate associated with the response IP address. Double
DnsResponseIpRegion The region, or state, within a country, associated with the source IP address. String
DnsResponseName The content of the response, as included in the record. The structure of the DNS response data may vary between different reporting devices. String
DnsSessionId The DNS session identifier as reported by the reporting device. String
Dst A unique identifier of the server that received the DNS request. String
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
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 server receiving the DNS request. For a regular DNS request, this value would typically be the reporting device, and in most cases set to 127.0.0.1. String
DstOriginalRiskLevel The risk level associated with the destination device as reported by the reporting device. String
DstPortNumber Destination Port number. Int32
DstRiskLevel The risk level associated with the destination device. Int32
Dvc A unique identifier of the device reporting the event. The identifier can be either an IP Address, A hostname, or a device ID. String
DvcAction The action taken by the the reporting device on the request, such as blocking it. 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 fully qualified hostname, including domain information, of the device reporting the event. String
DvcHostname The hostname of the device reporting the event. String
DvcId The unique ID of the device reporting the event. String
DvcIdType The type of DvcId. 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 reporting the event. 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
DvcScope The cloud platform scope the device belongs to. DvcScope map to a subscription ID on Azure and to an account ID on AWS. String
DvcScopeId The cloud platform scope ID the device belongs to. DvcScopeId map to a subscription ID on Azure and to an account ID on AWS. String
DvcZone The network segment of the device reporting the event. String
EventCount The number of events described by the record. This value is used when the source supports aggregation, and a single record may represent multiple events. Int32
EventEndTime The time at 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
EventOriginalSeverity The original severity as provided by the reporting device. This value is used to derive EventSeverity. String
EventOriginalType The original event type or ID, for example, the original Windows event ID. String
EventOriginalUid A unique ID of the original record. 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 of a resource that provides additional 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 DNS response code as defined by the Internet Assigned Numbers Authority (IANA). 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 at 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 Either request or response. String
EventType Indicates the operation reported by the record. For DNS activity events, this value is the DNS opcode as defined by the Internet Assigned Numbers Authority (IANA). String
EventVendor The vendor of the product generating the event. String
NetworkProtocol The transport protocol used by the network resolution event. The value can be UDP or TCP. String
NetworkProtocolVersion The version of the network protocol. Typically used to differentiate between IPv4 and Ipv6. String
RuleName The name or ID of the rule by associated with the inspection results. String
RuleNumber The number of the rule associated with the inspection results. Int32
SourceSystem String
Src A unique identifier of the source device. String
SrcDescription The number of the rule associated with the inspection results. 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
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. 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, or state, within a country, associated with the source IP address. String
SrcHostname The source device hostname, excluding domain information. String
SrcIpAddr The IP address of the client sending the DNS request. For a recursive DNS request, this value would typically be the reporting device, and in most cases, set to 127.0.0.1. String
SrcOriginalRiskLevel The risk level associated with the source device as reported by the reporting device. String
SrcOriginalUserType The original source user type, as provided by the source. String
SrcPortNumber Source port of the DNS query. Int32
SrcProcessGuid A generated unique identifier (GUID) of the process that initiated the DNS request. String
SrcProcessId The process ID (PID) of the process that initiated the DNS request. String
SrcProcessName The name of the process that initiated the DNS request. String
SrcRiskLevel The risk level associated with the source device. Int32
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 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
SrcUserSessionId The unique ID of the sign-in session of the source user. String
SrcUserType The type of the source user. String
TenantId String
ThreatCategory If a DNS event source also provides DNS security, it may also evaluate the DNS event. For example, it can search for the IP address or domain in a threat intelligence database, and assign the domain or IP address with a Threat Category. 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. String
ThreatFirstReportedTime_d 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. If a threat is identified in the Domain field, this field should be empty. 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. String
ThreatLastReportedTime_d The last time the IP address or domain were identified as a threat. DateTime
ThreatName The name of the threat identified, as reported by the reporting device. String
ThreatOriginalConfidence The original confidence level of the threat identified, as reported by the reporting device. String
ThreatOriginalRiskLevel The original risk level associated with the threat identified, as reported by the reporting device. Int32
ThreatOriginalRiskLevel_s The risk level associated with the threat identified, normalized to a value between 0 and a 100. String
ThreatRiskLevel The risk level associated with the threat identified, normalized to a value between 0 and a 100. Int32
TimeGenerated The timestamp (UTC) reflecting the time in which the event was generated. DateTime
TransactionIdHex The DNS unique hex transaction ID. String
Type The name of the table String
UrlCategory A DNS event source may also look up the category of the requested Domains. String

Schema changes #

Date Action
2024-10-18 Table added to tracking