from logs-aws.cloudtrail-* metadata _id, _version, _index
| where
event.provider == "iam.amazonaws.com"
and event.action == "AttachRolePolicy"
and event.outcome == "success"
// Extract policy name and role name from request parameters
| dissect aws.cloudtrail.request_parameters
"{%{?policyArn}=%{?arn}:%{?aws}:%{?iam}::%{?aws}:%{?policy}/%{Esql.aws_cloudtrail_request_parameters_policy_name},%{?roleName}=%{Esql.aws_cloudtrail_request_parameters_role_name}}"
// Filter for AdministratorAccess policy attachment
| where Esql.aws_cloudtrail_request_parameters_policy_name == "AdministratorAccess"
// keep relevant ECS and dynamic fields
| keep
@timestamp,
event.provider,
event.action,
event.outcome,
Esql.aws_cloudtrail_request_parameters_policy_name,
Esql.aws_cloudtrail_request_parameters_role_name
Install detection rules in Elastic Security
Detect AWS IAM AdministratorAccess Policy Attached to Role in the Elastic Security detection engine by installing this rule into your Elastic Stack.
To setup this rule, check out the installation guide for Prebuilt Security Detection Rules(opens in a new tab or window).