turbot/alicloud_insights

Query: ram_user_access_keys

Usage

powerpipe query alicloud_insights.query.ram_user_access_keys

SQL

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

Dashboards

The query is used in the dashboards: