turbot/alicloud_insights

Query: ram_groups_policies_count

Usage

powerpipe query alicloud_insights.query.ram_groups_policies_count

Steampipe Tables

SQL

select
jsonb_array_length(attached_policy) as value,
'Policies' as label,
case when jsonb_array_length(attached_policy) > 0 then 'ok' else 'alert' end as type
from
alicloud_ram_group
where
arn = $1
and account_id = split_part($1,':',4);

Dashboards

The query is used in the dashboards: