turbot/aws_insights

Query: iam_roles_by_boundary_policy

Usage

powerpipe query aws_insights.query.iam_roles_by_boundary_policy

Steampipe Tables

SQL

select
case
when permissions_boundary_type is null or permissions_boundary_type = '' then 'not configured'
else 'configured'
end as policy_type,
count(*)
from
aws_iam_role
group by
permissions_boundary_type;

Dashboards

The query is used in the dashboards: