Control: Old snapshots should be deleted if not required

Usage

Run the control in your terminal:

steampipe check alicloud_thrifty.control.ecs_snapshot_max_age

Snapshot and share results via Steampipe Cloud:

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

alicloud_ecs_snapshot

Params

90

SQL

select
  'acs:acs:' || region || ':' || account_id || ':' || 'snapshot/' || snapshot_id as resource,
  case
    when creation_time > current_timestamp - interval '90 days' then 'ok'
    else 'alarm'
  end as status,
  snapshot_id || ' created at ' || creation_time || ' (' || date_part('day', now() - creation_time) || ' days).'
  as reason,
  region,
  account_id
from
  alicloud_ecs_snapshot;

Tags