Skip to main content
Version: 3.2.6

How to Find AWS RDS instances do not have Auto Minor Version Upgrade enabled

Problem

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 Resoto to collect your AWS cloud resources.

Directions

  1. Execute the following search command in Resoto Shell or Resoto UI:

    > search is(aws_rds_instance) and rds_auto_minor_version_upgrade==false
    ​kind=aws_rds_instance, ..., region=resoto-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.

  3. Fix detected issues by following the remediation steps:

    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