turbot/alicloud_insights

Query: ram_role_with_admin_access_count

Usage

powerpipe query alicloud_insights.query.ram_role_with_admin_access_count

Steampipe Tables

SQL

select
count(distinct name) as value,
'With Administrator Access' as label,
case when count(distinct name) = 0 then 'ok' else 'alert' end as type
from
alicloud_ram_role,
jsonb_array_elements(attached_policy) as policies
where
policies ->> 'PolicyName' = 'AdministratorAccess';

Dashboards

The query is used in the dashboards: