inventory-vsphere

name: inventory-vsphere description: vSphere inventory field reference and TSL query examples. Use when querying VMware vSphere provider inventory (VMs, networks, datastores, hosts, clusters, folders).

vSphere Inventory Reference

Field names and query examples for VMware vSphere providers. Replace <PROVIDER> and <NS> with actual values.

VM Fields

Identity and State

Compute

Guest and Firmware

Storage and Security

VMware Tools and Snapshot

Concerns

Disks (disks[*])

NICs (nics[*])

Devices

Network Fields

Datastore Fields

Host Fields

Datacenter Fields

Cluster Fields

Folder Fields

VM Query Examples

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where name ~= 'prod-.*'", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where powerState = 'poweredOn' and memoryMB > 4096", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where firmware = 'efi' and guestName ~= '.*Windows.*'", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where any(disks[*].bus = 'nvme')", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where any(disks[*].rdm = true)", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where len(disks) > 1 and len(nics) >= 2", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where any(concerns[*].category = 'Critical')", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where snapshot.id != ''", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where toolsRunningStatus = 'guestToolsRunning'", "output": "markdown" } }

mtv_read { "command": "get inventory vm", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where powerState = 'poweredOn' order by memoryMB desc limit 10", "output": "markdown" } }

Infrastructure Query Examples

mtv_read { "command": "get inventory network", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where name ~= 'VM Network.*'", "output": "markdown" } }

mtv_read { "command": "get inventory datastore", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where type = 'VMFS' and free < 100Gi", "output": "markdown" } }

mtv_read { "command": "get inventory datastore", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where maintenance = 'normal' order by free asc", "output": "markdown" } }

mtv_read { "command": "get inventory host", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where inMaintenance = false and cpuCores >= 16", "output": "markdown" } }

mtv_read { "command": "get inventory folder", "flags": { "provider": "<PROVIDER>", "namespace": "<NS>", "query": "where path ~= '/Datacenter/vm/.*'", "output": "markdown" } }