turbot/steampipe-mod-aws-compliance

Control: RDS DB instance automatic minor version upgrade should be enabled

Description

Ensure that AWS Relational Database Service (RDS) database instances are configured for automatic minor version upgrades. The rule is non-compliant if the value of 'autoMinorVersionUpgrade' is false.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.rds_db_instance_automatic_minor_version_upgrade_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.rds_db_instance_automatic_minor_version_upgrade_enabled --share

SQL

This control uses a named query:

select
arn as resource,
case
when auto_minor_version_upgrade then 'ok'
else 'alarm'
end as status,
case
when auto_minor_version_upgrade then title || ' automatic minor version upgrades enabled.'
else title || ' automatic minor version upgrades not enabled.'
end as reason
, region, account_id
from
aws_rds_db_instance;

Tags