AWSCloudTrail

AWSCloudTrail Schema #

Table description #

TableSection TableType TableSectionName Description
Usx Regular Microsoft Sentinel CloudTrail logs, which ingested from Sentinel’s connector, holds all your data and management events of your Amazon Wev Services account.

Table retention #

HotDays ColdDays TotalInteractiveDays
14 76 90

Schema #

Name Description Type
_BilledSize Double
_IsBillable String
AdditionalEventData Additional data about the event that was not part of the request or response. String
APIVersion Identifies the API version associated with the AwsApiCall eventType value. String
AwsEventId GUID generated by CloudTrail to uniquely identify each event. You can use this value to identify a single event. String
AWSRegion The AWS region that the request was made to. String
AwsRequestId deprecated, please use AwsRequestId_ instead. String
AwsRequestId_ The value that identifies the request. The service being called generates this value. String
Category Shows the event category that is used in LookupEvents calls. String
CidrIp The CIDR IP is located under RequestParameters in CloudTrail, and it is used to specify the IP permissions for a security group rule. The IPv4 CIDR range. String
CipherSuite Optional. Part of tlsDetails. The cipher suite (combination of security algorithms used) of a request. String
ClientProvidedHostHeader Optional. Part of tlsDetails. The client-provided host name used in the service API call, which is typically the FQDN of the service endpoint. String
DestinationPort The DestinationPort is located under RequestParameters in CloudTrail, and it is used to specify the IP permissions for a security group rule. The end of port range for the TCP and UDP protocols, or an ICMP code. String
EC2RoleDelivery The friendly name of the user or role that issued the session. String
ErrorCode The AWS service error if the request returns an error. String
ErrorMessage The error description when available. This message includes messages for authorization failures. CloudTrail captures the message logged by the service in its exception handling. String
EventName The requested action, which is one of the actions in the API for that service. String
EventSource The service that the request was made to. This name is typically a short form of the service name without spaces plus .amazonaws.com. String
EventTypeName Identifies the type of event that generated the event record. This can be the one of the following values: AwsApiCall, AwsServiceEvent, AwsConsoleAction , AwsConsoleSignIn. String
EventVersion The version of the log event format. String
IpProtocol The IP protocol is located under RequestParameters in CloudTrail, and it is used to specify the IP permissions for a security group rule. The IP protocol name or number. The valid values are tcp, udp, icmp, or a protocol number. String
ManagementEvent A Boolean value that identifies whether the event is a management event. Boolean
OperationName Constant value: CloudTrail. String
ReadOnly Identifies whether this operation is a read-only operation. Boolean
RecipientAccountId Represents the account ID that received this event. The recipientAccountID may be different from the CloudTrail userIdentity Element accountId. This can occur in cross-account resource access. String
RequestParameters The parameters, if any, that were sent with the request. These parameters are documented in the API reference documentation for the appropriate AWS service. String
Resources A list of resources accessed in the event. String
ResponseElements The response element for actions that make changes (create, update, or delete actions). If an action does not change state (for example, a request to get or list objects), this element is omitted. String
ServiceEventDetails Identifies the service event, including what triggered the event and the result. String
SessionCreationDate The date and time when the temporary security credentials were issued. DateTime
SessionIssuerAccountId The account that owns the entity that was used to get credentials. String
SessionIssuerArn The ARN of the source (account, IAM user, or role) that was used to get temporary security credentials. String
SessionIssuerPrincipalId The internal ID of the entity that was used to get credentials. String
SessionIssuerType The source of the temporary security credentials, such as Root, IAMUser, or Role. String
SessionIssuerUserName The friendly name of the user or role that issued the session. String
SessionMfaAuthenticated The value is true if the root user or IAM user whose credentials were used for the request also was authenticated with an MFA device; otherwise, false. Boolean
SharedEventId GUID generated by CloudTrail to uniquely identify CloudTrail events from the same AWS action that is sent to different AWS accounts. String
SourceIpAddress The IP address that the request was made from. For actions that originate from the service console, the address reported is for the underlying customer resource, not the console web server. For services in AWS, only the DNS name is displayed. String
SourcePort The SourcePort is located under RequestParameters in CloudTrail, and it is used to specify the IP permissions for a security group rule. The start of port range for the TCP and UDP protocols, or an ICMP type number. String
SourceSystem Constant value: AWSCloudTrail. String
TenantId String
TimeGenerated The timestamp (UTC). An event’s time stamp comes from the local host that provides the service API endpoint on which the API call was made. DateTime
TlsVersion Optional. Part of tlsDetails. The TLS version of a request. String
Type The name of the table String
UserAgent The agent through which the request was made, such as the AWS Management Console, an AWS service, the AWS SDKs or the AWS CLI. String
UserIdentityAccessKeyId The access key ID that was used to sign the request. String
UserIdentityAccountId The account that owns the entity that granted permissions for the request. String
UserIdentityArn The Amazon Resource Name (ARN) of the principal that made the call. String
UserIdentityInvokedBy The name of the AWS service that made the request. String
UserIdentityPrincipalid A unique identifier for the entity that made the call. String
UserIdentityType The type of the identity. The following values are possible: Root, IAMUser, AssumedRole, FederatedUser, Directory, AWSAccount, AWSService, Unknown. String
UserIdentityUserName The name of the identity that made the call. String
VpcEndpointId Identifies the VPC endpoint in which requests were made from a VPC to another AWS service. String

Schema changes #

Date Action
2024-10-18 Table added to tracking