Control: Old block volume backups should be deleted if not required

Usage

Run the control in your terminal:

steampipe check oci_thrifty.control.block_volume_backup_max_age

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share oci_thrifty.control.block_volume_backup_max_age

oci_core_volume_backup

oci_identity_compartment

Params

90

SQL

select
  a.id as resource,
  case
    when extract(
      day
      from
        current_timestamp - a.time_created
    ) < $1 then 'ok'
    else 'alarm'
  end as status,
  a.display_name || ' created ' || to_char(a.time_created, 'DD-Mon-YYYY') || ' (' || extract(
    day
    from
      current_timestamp - a.time_created
  ) || ' days).' as reason,
  coalesce(c.name, 'root') as compartment,
  a.region
from
  oci_core_volume_backup as a
  left join oci_identity_compartment as c on c.id = a.compartment_id;

Tags