turbot/aws_insights

Query: iam_root_access_keys_table

Usage

powerpipe query aws_insights.query.iam_root_access_keys_table

SQL

select
a.title as "Account",
s.account_id as "Account ID",
s.account_access_keys_present as "Root Keys",
account_mfa_enabled as "Root MFA Enabled"
from
aws_iam_account_summary as s,
aws_account as a
where
a.account_id = s.account_id
order by
a.title;

Dashboards

The query is used in the dashboards: