turbot/alicloud_insights

Query: ram_groups_for_user

Usage

powerpipe query alicloud_insights.query.ram_groups_for_user

Steampipe Tables

SQL

select
g ->> 'GroupName' as "Name",
'acs:ram::' || account_id || ':group/' || (g ->> 'GroupName') as "Group ARN",
g ->> 'JoinDate' as "Join Date"
from
alicloud_ram_user as u,
jsonb_array_elements(groups) as g
where
u.arn = $1
and u.account_id = split_part($1,':',4);

Dashboards

The query is used in the dashboards: