turbot/oci_insights

Query: vcn_gateways_table

Usage

powerpipe query oci_insights.query.vcn_gateways_table

SQL

select
display_name as "Name",
'oci_core_internet_gateway' as "Type",
lifecycle_state as "Lifecycle State"
from
oci_core_internet_gateway
where
vcn_id = $1
union all
select
name as "Name",
'oci_core_local_peering_gateway' as "Type",
lifecycle_state as "State"
from
oci_core_local_peering_gateway
where
vcn_id = $1
union all
select
display_name as "Name",
'oci_core_nat_gateway' as "Type",
lifecycle_state as "State"
from
oci_core_nat_gateway
where
vcn_id = $1
union all
select
display_name as "Name",
'oci_core_service_gateway' as "Type",
lifecycle_state as "State"
from
oci_core_service_gateway
where
vcn_id = $1;

Dashboards

The query is used in the dashboards: