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:
powerpipe control run alicloud_thrifty.control.ecs_instance_long_running
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run alicloud_thrifty.control.ecs_instance_long_running --share
Steampipe Tables
Params
Args | Name | Default | Description | Variable |
---|---|---|---|---|
$1 | ecs_running_instance_age_max_days |
| The maximum number of days an instance are allowed to run. |
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, regionfrom alicloud_ecs_instancewhere status = 'Running';