turbot/alicloud_thrifty

GitHub
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

steampipe check alicloud_thrifty.control.ecs_instance_long_running

Plugins & Tables

Params

ArgsNameDefaultDescriptionVariable
$1ecs_running_instance_age_max_days
90
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,
region,
account_id
from
alicloud_ecs_instance
where
status = 'Running';

Tags