turbot/alicloud_insights

Query: ram_role_policy_count_for_role

Usage

powerpipe query alicloud_insights.query.ram_role_policy_count_for_role

Steampipe Tables

SQL

select
case when attached_policy = '[]' then 0 else jsonb_array_length(attached_policy) end as value,
'Policies' as label
from
alicloud_ram_role
where
arn = $1
and account_id = split_part($1,':',4);

Dashboards

The query is used in the dashboards: