turbot/aws_insights

Query: iam_roles_by_path

Usage

powerpipe query aws_insights.query.iam_roles_by_path

Steampipe Tables

SQL

select
case when path = '/' then '/*'
else '/' || (split_part(path, '/', 2)) || '/*' end as path_status,
count(*) as "total"
from
aws_iam_role
group by
path_status
order by
total desc;

Dashboards

The query is used in the dashboards: