turbot/alicloud_thrifty

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

Params

ArgsNameDefaultDescriptionVariable
$1ecs_instance_allowed_types
["%.nano","%.small","%._large",".__large"]
A list of allowed instance types. PostgreSQL wildcards are supported.

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;

Tags