How to Find AWS RDS Instances Without Auto Minor Version Upgrade Enabled

Auto Minor Version Upgrade is a feature that you can enable to have your database automatically upgraded when a new minor database engine version is available. Minor version upgrades often patch security vulnerabilities and fix bugs and therefore should be applied.

info

This security check is part of the CIS Amazon Web Services Benchmarks and is rated severity low.

Prerequisites

This guide assumes that you have already installed and configured Fix Inventory to collect your AWS resources.

Directions

1. Execute the following search command in Fix Inventory Shell:

   > search is(aws_rds_instance) and rds_auto_minor_version_upgrade==false
   ​kind=aws_rds_instance, ..., region=fixinventory-poweruser
   ​kind=aws_rds_instance, ..., account=poweruser-team

2. Pipe the search command into the dump command:

   > search is(aws_rds_instance) and rds_auto_minor_version_upgrade==false | dump
   ​reported:
   ​  id: /aws/rds/123
   ​  name: some-name
   ​  ctime: '2022-12-05T22:53:14Z'
   ​  kind: aws_rds_instance
   ​  age: 2mo28d

   The command output will list the details of all non-compliant aws_rds_instance resources.

Remediation

Enable auto minor version upgrade for all databases and environments that are matched by the search.

note

Please refer to the AWS RDS documentation for details.

Further Reading

• Search
• Command-Line Interface
• aws_rds_instance Resource Data Model

External Links

• CIS Amazon Web Services Benchmarks
• AWS Documentation