turbot/terraform_azure_compliance

Query: frontdoor_waf_enabled

Usage

powerpipe query terraform_azure_compliance.query.frontdoor_waf_enabled

Steampipe Tables

SQL

select
address as resource,
case
when (attributes_std -> 'routing_rule' -> 'frontend_endpoint') is null then 'alarm'
when (attributes_std -> 'routing_rule' -> 'frontend_endpoint' -> 'web_application_firewall_policy_link_id') is null then 'alarm'
else 'ok'
end status,
split_part(address, '.', 2) || case
when (attributes_std -> 'routing_rule' -> 'frontend_endpoint') is null then ' WAF disabled'
when (attributes_std -> 'routing_rule' -> 'frontend_endpoint' -> 'web_application_firewall_policy_link_id') is null then ' WAF disabled'
else ' WAF enabled'
end || '.' reason
, path || ':' || start_line
from
terraform_resource
where
type = 'azurerm_frontdoor';

Controls

The query is being used by the following controls: