turbot/alicloud_insights

Query: ram_access_key_age_table

Usage

powerpipe query alicloud_insights.query.ram_access_key_age_table

SQL

select
k.user_name as "User Name",
k.access_key_id as "Access Key ID",
now()::date - k.create_date::date as "Age in Days",
k.create_date as "Create Date",
'acs:ram::' || k.account_id || ':user/' || k.user_name as "User ARN",
k.status as "Status",
a.title as "Account",
k.account_id as "Account ID"
from
alicloud_ram_access_key as k,
alicloud_account as a
where
a.account_id = k.account_id
order by
k.create_date,
k.user_name;

Dashboards

The query is used in the dashboards: