CloudTrail JSON Files: Indexing Recommendations

As you plan to index CloudTrail JSON files, consider these indexing recommendations for your object groups:

The following sections provide some examples of the JSON settings for the array processing, tags management, and column renaming.

👍

With JSON Flex, JSON string columns have valuable analysis capabilities.

The fields and properties inside a JSON string can be searched using standard text search operations in Search Analytics or SQL Analytics. With JSON Flex, there are more options for using the JSON string fields in the Refinery views. When you create the Refinery view for the object group, you can use the Materialize with JSONPath or Materialize with JQ schema transformation to create one or more materialized columns from a JSON string value for filtering and some limited aggregations. You can use the Treat as Nested JSON transform to make a JSON string searchable with Elastic nested query expressions.

Use JSON String Indexing for Large Records Arrays with Minimal Filtering Value

To implement the recommendation to index Records.requestParameters and Records.responseElements as JSON strings, you create a JSON settings file that you can import to the Field Selection interface when creating object groups. (You can also pass this information in the format field payload of the createObjectGroup API.) A sample file follows:

{
    "field_selection_policy": [
        {
         "excludes": [
          "Records.requestParameters",
          "Records.responseElements"
         ],
         "type": "blacklist"
        }
    ],
    "vertical_selection_policy": [
     {
      "excludes": [
       "Records.requestParameters",
       "Records.responseElements"
      ],
      "type": "blacklist"
     }
    ]
}

{
  "bucket": "my-cloudtrail-objgrp",
  "source": "my-cloud-bucket",
  "format": {
    "_type": "JSON",
    "arrayFlattenDepth": 1,
    "stripPrefix": true,
    "horizontal": false,
    "fieldSelection": [
      {
        "excludes": [
          "Records.requestParameters",
          "Records.responseElements",
          "tags"
        ],
        "type": "blacklist"
      }
    ],
    "verticalSelection": [
      {
        "excludes": [
          "Records.requestParameters",
          "Records.responseElements"
        ],
        "type": "blacklist"
      }
    ]
  },
...

In the next topic for Refinery view settings, you can see how to configure these fields so that they can be searched using Elastic nested query syntax. Their information is still part of the index, but this change will reduce impacts to filter fields bloat.

Blacklist tags Array to Minimize Vertical Row Permutation and Duplication

During vertical expansion of nested JSON arrays, subarrays can sometimes cause some unintended side effects.

In a CloudTrail Records array, there is a tags subarray that contains AWS tags used for metadata labeling. An abbreviated sample log follows:

{
   "Records":[
      {
         "eventTime":"2021-03-06T21:22:54Z",
         "eventName":"StartInstances",
         "sourceIPAddress":"10.1.233.176",
         "counter":100,
         "tags":[
            {
               "t1":"val1",
               "t2":"val2"
            }
         ],
...

During vertical flattening, the tags array will create an extra row for each tag field in the array, and those almost duplicate rows (which vary only in the tag field value) can impact aggregations.

For example, flattened rows might look like the following in the indexed data, as duplicate rows with only the tag val1/val2 differences:

0,2021-03-06T21:22:54Z,StartInstances,10.1.233.176,100,val1,...
1,2021-03-06T21:22:54Z,StartInstances,10.1.233.176,100,val2,...

The extra rows affect the Discover Hits values for total records, inflate the totals for numeric fields (like counter) and aggregations like the number of StartInstances events, and so on.

To reduce the row permutations from flattening tags or similar arrays, you can blacklist the tags array to index it as a JSON string. These settings can be added to the JSON file that has the array settings from the previous section that you will import to the Field Selection interface when creating object groups. You can also pass this information in the format payload to the createObjectGroup API. A sample follows:

{
   "vertical_selection_policy":[
      {
         "excludes":[
           "tags"
         ],
         "type":"blacklist"
      }
   ]
}

{
  "bucket": "zzz-tags-blk-grp",
  "source": "chaosdemo-datasets",
  "format": {
    "_type": "JSON",
    "arrayFlattenDepth": 1,
    "stripPrefix": true,
    "horizontal": false,
    "verticalSelection": [
      {
        "excludes": [
          "tags"
        ],
        "type": "blacklist"
      }
    ]
  },
...

Just like the large Records.requestParameters and Records.responseElements arrays that were blacklisted in the previous section, the tags array content can be searched using Elastic nested query syntax.

Override the Data Type of Numeric IDs Fields

Fields like Records.accountId and Records.recipientAccountId usually contain all-number ID values like 012345678. These values are typically discovered and indexed as numeric fields, not strings. As a result, ID fields typically cannot be searched like other string fields. Also, IDs with leading zeros could be truncated when they are indexed, resulting in an incorrect ID value.

Number-based ID fields should not be used in metric aggregations like sums or max/min calculations. Although they look like numbers, they should be treated just like alphanumeric name strings.

With ChaosSearch, you can override the data type of numeric ID fields in the object group Schema Overrides. You can also pass this information in the payload to the createObjectGroup API.

JSON Column Renaming Recommendations

As shown in the sample CloudTrail log earlier in this topic, the JSON property names could be very long values due to the concatenation of nesting levels for arrays or object properties. For CloudTrail fields in the indexed data, many or all of the fields will begin with the prefix Records. because of the main array. Some sample field names follow:

Records.userIdentity.invokedBy
Records.tlsDetails.clientProvidedHostHeader
Records.eventCategory
Records.errorCode
Records.userIdentity.sessionContext.ec2RoleDelivery
Records.serviceEventDetails.statusMessage
Records.additionalEventData.SwitchTo
Records.serviceEventDetails.DocumentName
Records.additionalEventData.configRuleArn
Records.serviceEventDetails.snapshotId
Records.serviceEventDetails.IsS3EncryptionEnabled

The Records. prefix string is redundant and often can make the eventual Refinery view column names more complex to read and find desired fields, especially when the names are very long. Sometimes internal field names are not very meaningful, and they could be renamed to make them much clearer to users.

ChaosSearch object group controls include a column rename feature that can make these name changes to create shorter and more user-friendly column and filter names in their views. The colRenames syntax is part of the createObjectGroup API, but not yet part of the Create Object Group user interface (so they cannot yet be passed into the Field Selection file settings). Some sample column rename settings are shown below:

"colRenames": {
    "Records.userIdentity.invokedBy": "userIdentity.invokedBy",
    "Records.tlsDetails.clientProvidedHostHeader": "tlsDetails.clientProvidedHostHeader",
    "Records.eventCategory": "eventCategory",
    "Records.errorCode": "errorCode",
    "Records.userIdentity.sessionContext.ec2RoleDelivery": "userIdentity.sessionContext.ec2RoleDelivery",
    "Records.serviceEventDetails.statusMessage": "serviceEventDetails.statusMessage",
    "Records.additionalEventData.SwitchTo": "additionalEventData.SwitchTo",
    "Records.serviceEventDetails.DocumentName": "serviceEventDetails.DocumentName",
    "Records.additionalEventData.configRuleArn": "additionalEventData.configRuleArn",
    "Records.serviceEventDetails.snapshotId": "serviceEventDetails.snapshotId",
    "Records.serviceEventDetails.IsS3EncryptionEnabled": "serviceEventDetails.IsS3EncryptionEnabled",
}"

As a good practice, when you create some smaller sample CloudTrail object groups, review the field names created for the object group and evaluate whether the field names could be better by removing the Records. prefix and by other renaming to shorten or change the names to make them easier when they appear as fields in the Refinery view for analysis.