Loading controls...

Control: Long running instances should be reviewed

Description

Instances should ideally be ephemeral and rehydrated frequently. Check why these instances have been running for so long.

Usage

Run the control in your terminal:

steampipe check alicloud_thrifty.control.ecs_instance_long_running

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share alicloud_thrifty.control.ecs_instance_long_running

Plugins & Tables

alicloud_ecs_instance

Alibaba Cloud plugin

Params

Args	Name	Default	Description	Variable
$1	ecs_running_instance_age_max_days	`90`	The maximum number of days an instance are allowed to run.	ecs_running_instance_age_max_days

SQL

select
  arn as resource,
  case
    when date_part('day', now() - creation_time) > $1 then 'alarm'
    else 'ok'
  end as status,
  title || ' has been running ' || date_part('day', now() - creation_time) || ' days.' as reason,
  account_id,
  region
from
  alicloud_ecs_instance
where
  status = 'Running';

Tags

category = Cost

class = deprecated

plugin = alicloud

service = AliCloud/ECS