Query: keyvault_certificate_validity_period_less_equal_12_months

select
  c.id as resource,
  case
    when (x509_certificate_properties -> 'validity_months')::int <= 12 then 'ok'
    else 'alarm'
  end as status,
  c.title || ' validity period is ' || (x509_certificate_properties -> 'validity_months') || ' month(s).' as reason
  
  
  , sub.display_name as subscription
from
  azure_key_vault_certificate as c
  left join azure_subscription as sub on sub.subscription_id = c.subscription_id;