turbot/ibm_compliance

Query: iam_access_group_with_public_access

Usage

powerpipe query ibm_compliance.query.iam_access_group_with_public_access

Steampipe Tables

SQL

with account_public_access as (
select
name,
id,
account_id,
count(*) as public_access_grp_no
from
ibm_iam_access_group
where name = 'Public Access'
group by name,id,account_id
)
select
id as resource,
case
when name is null then 'ok'
else 'alarm'
end as status,
case
when name is null then 'No public access group configured in account.'
else name || ' group configured in account.'
end as reason,
account_id
from
account_public_access;

Controls

The query is being used by the following controls: