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

aws_ec2_instance

Params

Args	Name	Default	Description	Variable
$1	ec2_instance_allowed_types	`["%.nano","%.micro","%.small","%.medium","%.large","%.xlarge","%._xlarge"]`	A list of allowed instance types. PostgreSQL wildcards are supported.	ec2_instance_allowed_types

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;

Control: Large EC2 instances should be reviewed

Description

Usage

Steampipe Tables

Params

SQL

Tags