turbot/steampipe-mod-azure-compliance

Control: Web apps should have health check enabled

Description

Health check increases your application's availability by rerouting requests away from unhealthy instances and replacing instances if they remain unhealthy.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.appservice_web_app_health_check_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.appservice_web_app_health_check_enabled --share

SQL

This control uses a named query:

select
a.id as resource,
case
when configuration -> 'properties' ->> 'healthCheckPath' is not null then 'ok'
else 'alarm'
end as status,
case
when configuration -> 'properties' ->> 'healthCheckPath' is not null then a.name || ' health check enabled.'
else a.name || ' health check disabled.'
end as reason
, a.resource_group as resource_group
, sub.display_name as subscription
from
azure_app_service_web_app as a,
azure_subscription as sub
where
sub.subscription_id = a.subscription_id;

Tags