turbot/aws_insights

Query: iam_user_access_keys

Usage

powerpipe query aws_insights.query.iam_user_access_keys

SQL

select
access_key_id as "Access Key ID",
a.status as "Status",
a.create_date as "Create Date"
from
aws_iam_access_key as a left join aws_iam_user as u on u.name = a.user_name and u.account_id = a.account_id
where
u.arn = $1
and u.account_id = split_part($1, ':', 5);

Dashboards

The query is used in the dashboards: