turbot/alicloud_insights

Query: ram_user_age_table

Usage

powerpipe query alicloud_insights.query.ram_user_age_table

SQL

select
b.name as "Name",
now()::date - b.create_date::date as "Age in Days",
b.create_date as "Create Time",
b.arn as "ARN",
a.title as "Account",
b.account_id as "Account ID"
from
alicloud_ram_user as b,
alicloud_account as a
where
b.account_id = a.account_id
order by
b.create_date,
b.name;

Dashboards

The query is used in the dashboards: