Query: servicefabric_cluster_protection_level_as_encrypt_and_sign

select
  a.id as resource,
  case
    when fabric_settings @> '[{"parameters":[{"value": "EncryptAndSign"}]}]'::jsonb then 'ok'
    else 'alarm'
  end as status,
  case
    when fabric_settings @> '[{"parameters":[{"value": "EncryptAndSign"}]}]'::jsonb then a.name || ' ClusterProtectionLevel property set to EncryptAndSign.'
    else a.name || ' ClusterProtectionLevel property not set to EncryptAndSign.'
  end as reason
  
  , a.resource_group as resource_group
  , sub.display_name as subscription
from
  azure_service_fabric_cluster a
  left join azure_subscription as sub on sub.subscription_id = a.subscription_id;