Query: kubernetes_cluster_network_plugin_azure

select
  c.id as resource,
  case
    when network_profile ->> 'networkPlugin' = 'azure' then 'ok'
    else 'alarm'
  end as status,
  case
    when network_profile ->> 'networkPlugin' = 'azure' then c.name || ' Azure CNI networking enabled.'
    else c.name || ' Azure CNI networking disabled.'
  end as reason,
  c.resource_group as resource_group,
  sub.display_name as subscription
from
  azure_kubernetes_cluster c,
  azure_subscription sub
where
  sub.subscription_id = c.subscription_id;