Control: Ensure VPC Flow logs is enabled for every subnet in VPC Network
Usage
Run the control in your terminal:
powerpipe control run terraform_gcp_compliance.control.compute_subnetwork_flow_log_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_gcp_compliance.control.compute_subnetwork_flow_log_enabled --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std ->> 'purpose') in ('REGIONAL_MANAGED_PROXY', 'GLOBAL_MANAGED_PROXY') then 'skip' when (attributes_std -> 'log_config') is not null then 'ok' else 'alarm' end as status, split_part(address, '.', 2) || case when (attributes_std ->> 'purpose') in ('REGIONAL_MANAGED_PROXY', 'GLOBAL_MANAGED_PROXY') then ' flow logging not supported' when (attributes_std -> 'log_config') is not null then ' flow logging enabled' else ' flow logging disabled' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'google_compute_subnetwork';