turbot/alicloud_insights

Query: rds_instance_security_ips

Usage

powerpipe query alicloud_insights.query.rds_instance_security_ips

Steampipe Tables

SQL

select
s ->> 'DBInstanceIPArrayName' as "Instance IP Name",
s ->> 'SecurityIPType' as "Security IP Type",
s ->> 'WhitelistNetworkType' as "White List Network Type",
security_ip_mode as "Security Group IP Mode"
from
alicloud_rds_instance,
jsonb_array_elements(security_ips_src) as s
where
arn = $1
and account_id = split_part($1,':',5)
and region = split_part($1,':',4);

Dashboards

The query is used in the dashboards: