turbot/aws_compliance

Query: account_part_of_organizations

Usage

powerpipe query aws_compliance.query.account_part_of_organizations

Steampipe Tables

SQL

select
arn as resource,
case
when organization_id is not null then 'ok'
else 'alarm'
end as status,
case
when organization_id is not null then title || ' is part of organization(s).'
else title || ' is not part of organization.'
end as reason
, region, account_id
from
aws_account;

Controls

The query is being used by the following controls: