turbot/aws_insights

Query: rds_db_instance_security_groups

Usage

powerpipe query aws_insights.query.rds_db_instance_security_groups

Steampipe Tables

SQL

select
s ->> 'VpcSecurityGroupId' as "VPC Security Group ID",
s ->> 'Status' as "Status"
from
aws_rds_db_instance,
jsonb_array_elements(vpc_security_groups) as s
where
arn = $1;

Dashboards

The query is used in the dashboards: