turbot/azure_compliance

Query: network_lb_no_basic_sku

Usage

powerpipe query azure_compliance.query.network_lb_no_basic_sku

SQL

select
l.id as resource,
case
when l.sku_name = 'Basic' then 'alarm'
else 'ok'
end as status,
case
when l.sku_name = 'Basic' then l.title || ' using basic SKU.'
else l.title || ' using ' || sku_name || ' SKU.'
end as reason
, l.resource_group as resource_group
, sub.display_name as subscription
from
azure_lb as l,
azure_subscription as sub
where
sub.subscription_id = l.subscription_id;

Controls

The query is being used by the following controls: