Query: kusto_cluster_sku_with_sla

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;