turbot/steampipe-mod-aws-insights

Query: rds_db_instance_inventory_table

Usage

powerpipe query aws_insights.query.rds_db_instance_inventory_table

SQL

select
i.db_instance_identifier as "DB Instance Identifier",
i.create_time as "Create Time",
i.class as "Instance Class",
i.engine as "Engine",
i.engine_version as "Engine Version",
i.status as "Status",
i.availability_zone as "Availability Zone",
i.storage_type as "Storage Type",
i.allocated_storage as "Allocated Storage (GB)",
i.tags as "Tags",
i.arn as "ARN",
i.account_id as "Account ID",
a.title as "Account",
i.region as "Region"
from
aws_rds_db_instance as i
left join aws_account as a on i.account_id = a.account_id
order by
i.db_instance_identifier;

Dashboards

The query is used in the dashboards: