turbot/oci_insights

Query: compute_instance_vnic

Usage

powerpipe query oci_insights.query.compute_instance_vnic

Steampipe Tables

SQL

select
vnic_name as "VNIC Name",
private_ip as "Private IP",
public_ip as "Public IP",
time_created as "Time Created",
hostname_label as "Hostname Label",
is_primary as "Primary",
mac_address as "MAC Address"
from
oci_core_vnic_attachment
where
instance_id = $1 and public_ip is not null;

Dashboards

The query is used in the dashboards: