turbot/alicloud_insights

Query: ram_users_for_group

Usage

powerpipe query alicloud_insights.query.ram_users_for_group

Steampipe Tables

SQL

select
u ->> 'UserName' as "User Name",
'acs:ram::' || account_id || ':user/' || (u ->> 'UserName') as "User ARN",
u ->> 'DisplayName' as "Display Name",
u ->> 'JoinDate' as "Join Date"
from
alicloud_ram_group as g,
jsonb_array_elements(users) as u
where
arn = $1
and account_id = split_part($1,':',4);

Dashboards

The query is used in the dashboards: