Control: Unused log streams should be removed if not required

powerpipe control run aws_thrifty.control.cw_log_stream_unused

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

select
  arn as resource,
  case
    when last_ingestion_time is null then 'error'
    when date_part('day', now() - last_ingestion_time) > $1 then 'alarm'
    else 'ok'
  end as status,
  case
    when last_ingestion_time is null then name || ' is not reporting a last ingestion time.'
    else name || ' last log ingestion was ' || date_part('day', now() - last_ingestion_time) || ' days ago.'
  end as reason
  , region, account_id
from
  aws_cloudwatch_log_stream;