theapsgroup/vsphere

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

List hosts

select
*
from
vsphere_host;

Select all hosts by a vendor

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

Select all hosts with a 'red' status

select
*
from
vsphere_host
where
status = 'red';

.inspect vsphere_host

Vsphere hosts

NameTypeDescription
cputextThe CPU model
cpu_coresbigintNumber of physical CPU cores on the host
cpu_mhzbigintThe speed of the CPU cores. This is an average value if there are multiple speeds
cpu_threadsbigintNumber of physical CPU threads on the host
cpu_usagebigintCurrent cpu usage in mhz
memorybigintThe physical memory size in bytes
memory_usagebigintCurrent memory usage in MB
modeltextThe system model identification
nametextThe name of the host
num_hbasbigintThe number of host bus adapters
num_nicsbigintThe number of network adapters
statustextThe status of the host
uptimebigintThe uptime in seconds
vendortextThe hardware vendor identification