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

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

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