Query: compute_virtual_machine_encryption_status

select
  'Host Encryption' as label,
  case
    when security_profile -> 'encryptionAtHost' <> 'true'
    or security_profile -> 'encryptionAtHost' is null then 'Disabled'
    else 'Enabled'
  end as value,
  case
    when security_profile -> 'encryptionAtHost' <> 'true'
    or security_profile -> 'encryptionAtHost' is null then 'alert'
    else 'ok'
  end as type
from
  azure_compute_virtual_machine
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);