Control: Long running EC2 instances should be reviewed

powerpipe control run aws_thrifty.control.long_running_ec2_instances

powerpipe login
powerpipe control run aws_thrifty.control.long_running_ec2_instances --share

select
  arn as resource,
  case
    when date_part('day', now()-launch_time) > $1 then 'alarm'
    else 'ok'
  end as status,
  title || ' has been running ' || date_part('day', now()-launch_time) || ' days.' as reason
  
  , region, account_id
from
  aws_ec2_instance
where
  -- Instance is running
  instance_state in ('running', 'pending', 'rebooting');