turbot/alicloud_insights

Query: ram_roles_without_policy_count

Usage

powerpipe query alicloud_insights.query.ram_roles_without_policy_count

Steampipe Tables

SQL

select
count(*) as value,
'Without Policies' as label,
case
when count(*) > 0 then 'alert'
else 'ok'
end as type
from
alicloud_ram_role
where
attached_policy = '[]';

Dashboards

The query is used in the dashboards: