Control: Large ECS instances should be reviewed

Description

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

Usage

Run the control in your terminal:

powerpipe control run alicloud_thrifty.control.ecs_instance_large

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run alicloud_thrifty.control.ecs_instance_large --share

Steampipe Tables

alicloud_ecs_instance

Params

Args	Name	Default	Description	Variable
$1	ecs_instance_allowed_types	`["%.nano","%.small","%._large",".__large"]`	A list of allowed instance types. PostgreSQL wildcards are supported.	ecs_instance_allowed_types

SQL

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

Control: Large ECS instances should be reviewed

Description

Usage

Steampipe Tables

Params

SQL

Tags