turbot/steampipe-mod-azure-compliance

Control: Web apps should be configured to always be on

Description

This control ensures that a web app is configured with settings to keep it consistently active. Always On feature of Azure App Service, keeps the host process running. This allows your site to be more responsive to requests after significant idle periods.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.appservice_web_app_always_on

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
a.id as resource,
case
when configuration -> 'properties' ->> 'alwaysOn' = 'true' then 'ok'
else 'alarm'
end as status,
case
when configuration -> 'properties' ->> 'alwaysOn' = 'true' then a.name || ' alwaysOn is enabled.'
else a.name || ' alwaysOn is 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