turbot/azure_compliance

Query: network_public_ip_no_basic_sku

Usage

powerpipe query azure_compliance.query.network_public_ip_no_basic_sku

SQL

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

Controls

The query is being used by the following controls: