Query: ecs_cluster_instance_in_vpc

select
  c.arn as resource,
  case
    when i.vpc_id is null then 'alarm'
    else 'ok'
  end as status,
  case
    when i.vpc_id is null then c.title || ' not in VPC.'
    else c.title || ' in VPC.'
  end as reason
  
  , c.region, c.account_id
from
  aws_ecs_container_instance as c
  left join aws_ec2_instance as i on c.ec2_instance_id = i.instance_id;