Query: compute_instance_shielded_vm_status

with instances as (
  select
    case
      when shielded_instance_config @> '{"enableVtpm": true, "enableIntegrityMonitoring": true}' then 'enabled'
      else 'disabled'
    end as shielded_vm_status
  from
    gcp_compute_instance
)
select
  shielded_vm_status,
  count(*)
from
  instances
group by
  shielded_vm_status;