turbot/alicloud_insights

Query: ram_policy_attached

Usage

powerpipe query alicloud_insights.query.ram_policy_attached

Steampipe Tables

SQL

select
case
when attachment_count > 0 then 'Attached'
else 'Detached'
end as value,
'Attachment Status' as label,
case
when attachment_count > 0 then 'ok'
else 'alert'
end as type
from
alicloud_ram_policy
where
policy_name = $1;

Dashboards

The query is used in the dashboards: