steampipe plugin install theapsgroup/vspheresteampipe plugin install theapsgroup/vsphere

Table: vsphere_host

A host is a machine that provides the compute for virtual machines and other vSphere features.

The vsphere_host table can be used to query host utilization and hardware information.

Examples

select
  *
from
  vsphere_host;

select
  *
from
  vsphere_host
where
  vendor LIKE '%Dell%';

select
  *
from
  vsphere_host
where
  status = 'red';

Vsphere hosts

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
cpu	text	The CPU model
cpu_cores	bigint	Number of physical CPU cores on the host
cpu_mhz	bigint	The speed of the CPU cores. This is an average value if there are multiple speeds
cpu_threads	bigint	Number of physical CPU threads on the host
cpu_usage	bigint	Current cpu usage in mhz
memory	bigint	The physical memory size in bytes
memory_usage	bigint	Current memory usage in MB
model	text	The system model identification
moref	text	Managed object reference of the host
name	text	The name of the host
num_hbas	bigint	The number of host bus adapters
num_nics	bigint	The number of network adapters
product	text	The complete VMware product name, including the version information.
status	text	The status of the host
uptime	bigint	The uptime in seconds
vendor	text	The hardware vendor identification