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 = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);