Control: Old Autonomous databases should be reviewed

powerpipe control run oci_thrifty.control.database_autonomous_database_max_age

powerpipe login
powerpipe control run oci_thrifty.control.database_autonomous_database_max_age --share

select
  a.id as resource,
  case
    when date_part('day', now()-a.time_created) > $1 then 'alarm'
    when date_part('day', now()-a.time_created) > $2 then 'info'
    else 'ok'
  end as status,
  a.title || ' of type ' || a.db_workload || ' has been in use for ' || date_part('day', now()-a.time_created) || ' days.' as reason,
  coalesce(c.name, 'root') as compartment
  
  , a.region
from
  oci_database_autonomous_database as a
  left join oci_identity_compartment as c on c.id = a.compartment_id
where
  a.lifecycle_state <> 'DELETED';