turbot/steampipe-mod-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
left join azure_subscription as sub on i.subscription_id = sub.subscription_id;

Controls

The query is being used by the following controls: