turbot/oci_insights

Query: vcn_network_security_group_tag

Usage

powerpipe query oci_insights.query.vcn_network_security_group_tag

SQL

with jsondata as (
select
tags::json as tags
from
oci_core_network_security_group
where
id = $1 and lifecycle_state <> 'TERMINATED'
)
select
key as "Key",
value as "Value"
from
jsondata,
json_each_text(tags)
order by
key;

Dashboards

The query is used in the dashboards: