turbot/aws_insights

Query: iam_users_by_account

Usage

powerpipe query aws_insights.query.iam_users_by_account

Steampipe Tables

SQL

select
a.title,
count(*)
from
aws_iam_user as u,
aws_account as a
where
u.account_id = a.account_id
group by
a.title
order by
count desc;

Dashboards

The query is used in the dashboards: