turbot/alicloud_compliance

Query: rds_instance_restrict_access_to_internet

Usage

powerpipe query alicloud_compliance.query.rds_instance_restrict_access_to_internet

Steampipe Tables

SQL

select
arn as resource,
case
when security_ips :: jsonb ? '0.0.0.0/0' then 'alarm'
else 'ok'
end as status,
case
when security_ips :: jsonb ? '0.0.0.0/0' then title || ' publicly accessible.'
else title || ' not publicly accessible.'
end as reason,
account_id as account_id,
region as region
from
alicloud_rds_instance;

Controls

The query is being used by the following controls: