turbot/aws_insights

Query: iam_groups_with_inline_policy

Usage

powerpipe query aws_insights.query.iam_groups_with_inline_policy

Steampipe Tables

SQL

with group_inline_compliance as (
select
arn,
case
when jsonb_array_length(inline_policies) > 0 then 'with inline policies'
else 'no inline policies'
end as has_inline
from
aws_iam_group
)
select
has_inline,
count(*)
from
group_inline_compliance
group by
has_inline;

Dashboards

The query is used in the dashboards: