Control: App Service apps should have remote debugging turned off
Description
Remote debugging requires inbound ports to be opened on an App Service app. Remote debugging should be turned off.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.appservice_api_app_remote_debugging_disabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.appservice_api_app_remote_debugging_disabled --share
SQL
This control uses a named query:
select app.id as resource, case when kind <> 'api' then 'skip' when configuration -> 'properties' ->> 'remoteDebuggingEnabled' = 'false' then 'ok' else 'alarm' end as status, case when kind <> 'api' then name || ' is of ' || kind || ' type.' when configuration -> 'properties' ->> 'remoteDebuggingEnabled' = 'false' then name || ' remote debugging disabled.' else name || ' remote debugging enabled.' end as reason , app.resource_group as resource_group , sub.display_name as subscriptionfrom azure_app_service_web_app as app, azure_subscription as subwhere sub.subscription_id = app.subscription_id;