Control: Appservice plan should not use free, shared or basic SKU
Description
The Free, Shared, and Basic plans are suitable for constrained testing and development purposes. This control is considered non-compliant when free, shared, or basic SKUs are utilized.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.appservice_plan_minimum_sku
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.appservice_plan_minimum_sku --share
SQL
This control uses a named query:
select a.id as resource, case -- The below basic plans are used for development and testing purposes. when sku_name in ('F1', 'D1', 'B1', 'B2', 'B3') then 'alarm' else 'ok' end as status, a.name || ' is of ' || sku_family || ' SKU family.' as reason , a.resource_group as resource_group , sub.display_name as subscriptionfrom azure_app_service_plan as a, azure_subscription as subwhere sub.subscription_id = a.subscription_id;