Query: compute_instance_shielded_vm

select
  case
    when (
      shielded_instance_config -> 'enableIntegrityMonitoring'
    ) :: bool then 'Enabled'
    else 'Disabled'
  end as "Integrity Monitoring",
  case
    when (shielded_instance_config -> 'enableVtpm') :: bool then 'Enabled'
    else 'Disabled'
  end "vTPM",
  case
    when (shielded_instance_config -> 'enableSecureBoot') :: bool then 'Enabled'
    else 'Disabled'
  end "Secure Boot"
from
  gcp_compute_instance
where
  id = $1;