turbot/aws_thrifty

Control: Are there RDS instances using previous gen instance types?

Description

M5 and T3 instance types are less costly than previous generations

Usage

Run the control in your terminal:

powerpipe control run aws_thrifty.control.latest_rds_instance_types

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_thrifty.control.latest_rds_instance_types --share

Steampipe Tables

SQL

select
arn as resource,
case
when class like '%.t2.%' then 'alarm'
when class like '%.m3.%' then 'alarm'
when class like '%.m4.%' then 'alarm'
when class like '%.m5.%' then 'ok'
when class like '%.t3.%' then 'ok'
else 'info'
end as status,
title || ' has a ' || class || ' instance class.' as reason
, region, account_id
from
aws_rds_db_instance;

Tags