turbot/gcp_insights

Query: compute_instance_confidential_vm_service_status

Usage

powerpipe query gcp_insights.query.compute_instance_confidential_vm_service_status

Steampipe Tables

SQL

with instances as (
select
case
when confidential_instance_config <> '{}' then 'enabled'
else 'disabled'
end as confidential_instance_status
from
gcp_compute_instance
)
select
confidential_instance_status,
count(*)
from
instances
group by
confidential_instance_status;

Dashboards

The query is used in the dashboards: