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

Dashboards

The query is used in the dashboards: