Control: EC2 instances should be in a VPC
Description
Deploy EC2 instances within a VPC to enable secure communication between an instance and other services within the VPC, without requiring an internet gateway, NAT device, or VPN connection.
Usage
Run the control in your terminal:
powerpipe control run aws_perimeter.control.ec2_instance_in_vpcSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_perimeter.control.ec2_instance_in_vpc --shareSteampipe Tables
SQL
select  arn as resource,  case    when vpc_id is null then 'alarm'    else 'ok'  end as status,  case    when vpc_id is null then title || ' not in VPC.'    else title || ' in VPC.'  end as reason    , region, account_idfrom  aws_ec2_instance;