Query: vpc_no_flow_logs_count

select
  count(*) filter(
    where
      vpc_id not in (
        select
          resource_id
        from
          aws_vpc_flow_log
      )
  ) as value,
  'Flow Logs Disabled' as label,
  case
    count(*) filter(
      where
        vpc_id not in (
          select
            resource_id
          from
            aws_vpc_flow_log
        )
    )
    when 0 then 'ok'
    else 'alert'
  end as type
from
  aws_vpc;