turbot/aws_thrifty
Loading controls...

Control: Large EC2 instances should be reviewed

Description

Large EC2 instances are unusual, expensive and should be reviewed.

Usage

Run the control in your terminal:

powerpipe control run aws_thrifty.control.large_ec2_instances

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

Params

ArgsNameDefaultDescriptionVariable
$1ec2_instance_allowed_types
["%.nano","%.micro","%.small","%.medium","%.large","%.xlarge","%._xlarge"]
A list of allowed instance types. PostgreSQL wildcards are supported.

SQL

select
arn as resource,
case
when instance_state not in ('running', 'pending', 'rebooting') then 'info'
when instance_type like any ($1) then 'ok'
else 'alarm'
end as status,
title || ' has type ' || instance_type || ' and is ' || instance_state || '.' as reason,
region,
account_id
from
aws_ec2_instance;

Tags