Control: Long running compute instances should be reviewed

powerpipe control run oci_thrifty.control.compute_instance_long_running

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

select
  a.id as resource,
  case
    when a.lifecycle_state <> 'RUNNING' then 'skip'
    when date_part('day', now() - a.time_created) > $1 then 'alarm'
    else 'ok'
  end as status,
  case
    when a.lifecycle_state <> 'RUNNING' then a.title || ' in ' || a.lifecycle_state || ' state.'
    else a.title || ' has been running ' || date_part('day', now() - a.time_created) || ' days.'
  end as reason,
  coalesce(c.name, 'root') as compartment
  
  , a.region
from
  oci_core_instance as a
  left join oci_identity_compartment as c on c.id = a.compartment_id;