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_hostwhere vendor LIKE '%Dell%';
Select all hosts with a 'red' status
select *from vsphere_hostwhere status = 'red';
.inspect vsphere_host
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 |