turbot/alicloud_insights

Query: ram_groups_by_account

Usage

powerpipe query alicloud_insights.query.ram_groups_by_account

SQL

select
a.title as "account",
count(g.*) as "total"
from
alicloud_ram_group as g,
alicloud_account as a
where
a.account_id = g.account_id
group by
account
order by count(g.*) desc;

Dashboards

The query is used in the dashboards: