steampipe plugin install theapsgroup/vsphere

Table: vsphere_network

A network is an isolated virtual network that vms can use to communicate between each other or to the internet.

The vsphere_network table can be used to query networks and availability.

Examples

List networks

select
*
from
vsphere_network;

Select all accessible networks

select
*
from
vsphere_network
where
accessible = true;

Select networks with test in their name

select
*
from
vsphere_network
where
name ILIKE '%test%';

Schema for vsphere_network

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
accessiblebooleanAt least one host is configured to provide this network
ip_pool_idbigintIdentifier of the associated IP pool. Zero if the network is not associated with an IP pool
ip_pool_nametextName of the associated IP pool. Empty if the network is not associated with an IP pool
moreftextManaged object reference of the network
nametextThe name of the network
typetextThe type of the network