Skip to main content

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​