turbot/azure_compliance

Query: kusto_cluster_sku_with_sla

Usage

powerpipe query azure_compliance.query.kusto_cluster_sku_with_sla

SQL

select
kv.id as resource,
case
when sku_name in ('Dev(No SLA)_Standard_E2a_v4' , 'Dev(No SLA)_Standard_D11_v2') then 'alarm'
else 'ok'
end as status,
name || ' using ' || sku_name || ' SKU tier.' as reason
, kv.resource_group as resource_group
, sub.display_name as subscription
from
azure_kusto_cluster as kv,
azure_subscription as sub
where
sub.subscription_id = kv.subscription_id;

Controls

The query is being used by the following controls: