# Saved Logs Insights queries for working a case. They appear under Queries # in the CloudWatch console, in a folder named after var.name. Set the time # range in the console before running one. locals { queries = merge({ # Who gave whom new access. Run it first when an alarm names a person, to # see whether their access changed in the days before. permission-changes = { groups = [var.trail_log_group] query = <<-EOT fields @timestamp, userIdentity.arn, eventName, requestParameters.roleName, requestParameters.userName, requestParameters.groupName, requestParameters.policyArn | filter eventSource = "iam.amazonaws.com" | filter eventName in ["AttachRolePolicy", "PutRolePolicy", "AttachUserPolicy", "PutUserPolicy", "AddUserToGroup", "UpdateAssumeRolePolicy", "CreateAccessKey", "CreateLoginProfile"] | sort @timestamp desc EOT } # Everything one principal did. Replace the ARN, or match on part of it. one-principal = { groups = local.reads_on ? [var.trail_log_group, local.read_group] : [var.trail_log_group] query = <<-EOT fields @timestamp, eventSource, eventName, requestParameters.bucketName, requestParameters.key, sourceIPAddress, errorCode | filter userIdentity.arn like /REPLACE-WITH-ROLE-OR-USER-NAME/ | sort @timestamp asc EOT } # The changes that alarm, with who made them, for reviewing a week at once. changes-by-person = { groups = [var.trail_log_group] query = <<-EOT fields @timestamp, userIdentity.arn, eventName, requestParameters.bucketName, requestParameters.keyId, sourceIPAddress, errorCode | filter eventName in ["PutBucketPolicy", "PutBucketAcl", "DeleteBucketPublicAccessBlock", "DeleteAccountPublicAccessBlock", "PutBucketReplication", "ModifySnapshotAttribute", "ModifyImageAttribute", "ModifyDBSnapshotAttribute", "ModifyDBClusterSnapshotAttribute", "PutKeyPolicy", "StopLogging", "DeleteTrail", "UpdateTrail", "PutEventSelectors", "DeleteFlowLogs"] | sort @timestamp desc EOT } # Grants that let someone decrypt, made by a person rather than a service. decrypt-grants = { groups = [var.trail_log_group] query = <<-EOT fields @timestamp, userIdentity.arn, requestParameters.keyId, requestParameters.granteePrincipal, requestParameters.operations.0, sourceIPAddress | filter eventSource = "kms.amazonaws.com" and eventName = "CreateGrant" | filter not ispresent(userIdentity.invokedBy) | sort @timestamp desc EOT } }, local.reads_on ? { # Who read the most, hour by hour. bulk-readers = { groups = [local.read_group] query = <<-EOT stats count(*) as objects, count_distinct(requestParameters.bucketName) as buckets by userIdentity.arn, bin(1h) as hour | sort objects desc | limit 50 EOT } } : {}) } resource "aws_cloudwatch_query_definition" "insider" { for_each = local.queries name = "${var.name}/${each.key}" log_group_names = each.value.groups query_string = each.value.query depends_on = [aws_cloudwatch_log_group.reads] }