ASimFileEventLogs

ASimFileEventLogs Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel The Advanced Security Information Model (ASIM) File Event normalization schema describes file activity such as creating, modifying, or deleting files or documents.

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
ActingProcessCommandLine The command line used to run the acting process. String
ActingProcessGuid A generated unique identifier (GUID) of the acting process. String
ActingProcessId The process ID (PID) of the acting process. String
ActingProcessName The name of the acting process. String
ActorOriginalUserType The original actor user type as provided by the reporting device. String
ActorScope The scope, such as Azure AD tenant, in which ActorUserId and ActorUsername are defined. String
ActorScopeId The scope ID, such as Azure AD Directory ID, in which ActorUserId and ActorUsername are defined. String
ActorSessionId The unique ID of the login session of the Actor. String
ActorUserAadId The Azure Active Directory ID of the actor. String
ActorUserId A machine-readable, alphanumeric, unique representation of the actor. String
ActorUserIdType The type of the ID stored in the ActorUserId field. String
ActorUsername The Actor username, including domain information when available. String
ActorUsernameType Specifies the type of the user name stored in the ActorUsername field. String
ActorUserSid The Windows user ID (SIDs) of the actor. String
ActorUserType The type of actor. String
AdditionalFields Additional information, represented using key/value pairs provided by the source which do not map to ASim. Object
DvcAction The action taken on the web session. String
DvcDescription A descriptive text associated with the device. String
DvcDomain The domain of the device reporting the event. String
DvcDomainType The type of DvcDomain. Valid 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
DvcInterface The original DvcAction as provided by the reporting 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. String
DvcOriginalAction The original DvcAction as provided by the reporting device. String
DvcOs The operating system running on the device on which the event occurred or which reported the event. String
DvcOsVersion The version of the operating system on the device on which the event occurred or which reported the event. String
DvcScope The cloud platform scope the device belongs to. DvcScope map to a subscription name 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 on which the event occurred or which reported the event, depending on the schema. 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
EventSchema The schema the event is normalized to. Each schema documents its schema name. 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
HashType The type of hash stored in the Hash alias field. String
HttpUserAgent When the operation is initiated using HTTP or HTTPS, the HTTP user agent header. String
NetworkApplicationProtocol When the operation is initiated by a remote system, the application layer protocol used by the connection or session. 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
SrcDescription A descriptive text associated with the device. 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 device belongs to. String
SrcDvcScopeId The cloud platform scope ID the device belongs to. String
SrcFileCreationTime The time at which the source file was created. DateTime
SrcFileDirectory The source file folder or location. String
SrcFileExtension The source file extension. String
SrcFileMD5 The MD5 hash of the source file. String
SrcFileMimeType The Mime or Media type of the source file. String
SrcFileName The name of the source file, without a path or a location, but with an extension if relevant. String
SrcFilePath The full, normalized path of the source file, including the folder or location, the file name, and the extension. String
SrcFilePathType The type of SrcFilePath. String
SrcFileSHA1 The SHA-1 hash of the source file. String
SrcFileSHA256 The SHA-256 hash of the source file. String
SrcFileSHA512 The SHA-512 hash of the source file. String
SrcFileSize The size of the source file in bytes. Int64
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, store the relevant IP address in this field. String
SrcIpAddr When the operation is initiated by a remote system, the IP address of this system. String
SrcMacAddr The MAC address of the source device. String
SrcOriginalRiskLevel The risk level associated with the source. As reported by the reporting device or enriched. String
SrcPortNumber When the operation is initiated by a remote system, the port number from which the connection was initiated. Int32
SrcRiskLevel The risk level associated with the source. Int32
TargetAppId The ID of the destination application, as reported by the reporting device. String
TargetAppName The name of the destination application. String
TargetAppType The type of the destination application. String
TargetFileCreationTime The time at which the target file was created. DateTime
TargetFileDirectory The target file folder or location. String
TargetFileExtension The target file extension. String
TargetFileMD5 The MD5 hash of the target file. String
TargetFileMimeType The Mime or Media type of the target file. String
TargetFileName The name of the target file, without a path or a location, but with an extension if relevant. String
TargetFilePath The full, normalized path of the target file, including the folder or location, the file name, and the extension. String
TargetFilePathType The type of TargetFilePath. String
TargetFileSHA1 The SHA-1 hash of the target file. String
TargetFileSHA256 The SHA-256 hash of the target file. String
TargetFileSHA512 The SHA-512 hash of the source file. String
TargetFileSize The size of the target file in bytes. Int64
TargetOriginalAppType The target application type as reported by the reporting device. String
TargetUrl When the operation is initiated using HTTP or HTTPS, the URL used. String
TenantId String
ThreatCategory The category of the threat or malware identified in the file activity. 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 SrcFilePath or DstFilePath. String
ThreatFilePath A file path for which a threat was identified. The field ThreatField contains the name of the field ThreatFilePath represents. 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 file activity. 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 file activity. 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 identified threat. The level should be a number between 0 and 100. Int32
TimeGenerated The timestamp 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