Control: RDS MySQL and PostgreSQL DB instances with unsupported version should be reviewed
Description
MySQL 5.7 and PostgreSQL 11 database instances running on Amazon Aurora and Amazon Relational Database Service (Amazon RDS) will be automatically enrolled into Amazon RDS Extended Support. This automatic enrollment may mean that you will experience higher charges when RDS Extended Support begins. You can avoid these charges by upgrading your database to a newer DB version.
Usage
Run the control in your terminal:
powerpipe control run aws_thrifty.control.rds_mysql_postresql_db_no_unsupported_versionSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_thrifty.control.rds_mysql_postresql_db_no_unsupported_version --shareSteampipe Tables
SQL
select arn as resource, engine_version, engine, case when not engine ilike any (array ['%mysql%', '%postgres%']) then 'skip' when (engine like '%mysql' and engine_version like '5.7.%' ) or (engine like '%postgres%' and engine_version like '11.%') then 'alarm' else 'ok' end as status, case when not engine ilike any (array ['%mysql%', '%postgres%']) then title || ' is of ' || engine || ' engine type.' when (engine like '%mysql' and engine_version like '5.7.%' ) or (engine like '%postgres%' and engine_version like '11.%') then title || ' is using RDS Extended Support.' else title || ' is not using RDS Extended Support.' end as reason , region, account_idfrom aws_rds_db_instance;