turbot/gcp_insights

Query: compute_instance_shielded_vm

Usage

powerpipe query gcp_insights.query.compute_instance_shielded_vm

Steampipe Tables

SQL

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;

Dashboards

The query is used in the dashboards: