Optical Prime VMware Excel Definitions – Live Optics Support

This document outlines the definitions used in the Optical Prime VMware Excel. All capacity values are calculated per base 2 (1024).

Details

This worksheet provides some summary information about the project.

Field	Description
Project ID	The project ID
Project Name	The project Name
Date	The creation date for the project in YYYY/MM/DD format.
Owner	The first and last name of the project owner with the email address in parenthesis. e.g. John Doe (john.doe@whatever.com)
Collector Build Version	The build version of the collector that generated the first Collector Run in this project.
Glossary Knowledge Base Article Link	URL to the Glossary for this spreadsheet to be provided by TPM before release.
Spreadsheet Version	The build version of the code that generated the spreadsheet. e.g. 21.1.1.1

ESX Hosts

Each row in this tab represents a VMware ESXi hypervisor and displays basic inventory and configuration information for that host.

Field	Description
Host-Name	The name of the ESXi hypervisor Note: Usually the DNS name, but sometimes just an IP address
Datacenter	The name of the virtual datacenter that contains this ESXi server belongs
vCenter	The version of vCenter that is monitoring this ESXi host
Cluster	The name of the cluster that contains this ESXi host Note: If the host is not in a cluster, then this field will be blank.
OS	The version of ESXi (or ESX if old enough) that this host is running
Manufacturer	The manufacturer of the physical server (hardware) of this host
Model	The model number of the physical server (hardware) of this host
Serial No.	The service tag or serial number of the physical server (hardware) of this host Note: If this is a blade server, this should be the service tag for the blade server itself (not the chassis).
CPU Sockets	The total number of CPU sockets (CPU packages) running on this host. Note: This only represents the running CPU sockets. If a socket is not equipped with a CPU or is otherwise disabled in the BIOS, then that socket will not be included in this count.
CPU Cores	The total number of CPU cores running on this host
CPU Description	The manufacturer and model information of the CPU type installed on this host
Net Clock Speed (GHz)	The sum of the clock speed for each CPU core running on this host measured in GHz
CPU Clock Speed (GHz)	The clock speed of each individual CPU core running on this host measured in GHz
CPU Threads	The total number of threads (e.g. hyper-threading) supported for all running CPUs and cores on this host
Memory (KiB)	The server RAM memory in kilobytes.
Local Capacity (GiB)	The total size of any disk storage local to this server Note: This includes local datastores, local RDM devices, local backup drives, and any disk storage not shared with other hosts in this project.
Free Capacity (GiB)	The unused portion of disk storage local to this server as defined in Local Capacity above
Used Capacity (GiB)	The used portion of disk storage local to this server as defined in Local Capacity above
Guest VM Count	The total number of guest virtual machines that are on this host Note: This includes running and non-running guest virtual machines.
Number of NICs	The total number of network interface connection ports on the physical hypervisor host
Number of HBAs	The total number of storage host bus adapters installed on the physical hypervisor host
IP1	The first IP address assigned to this host
IP2	The second IP address assigned to this host (if any)
IP3	The third IP address assigned to this host (if any) Note: ESXi hypervisors can obviously be configured with more than 3 IP addresses, but this report only will show the first three. IPv4 addresses are shown over IPv6 addresses.
Config Status	The overall status of the ESXi host as known by vCenter gray - the status is unknown to vCenter green - the host is connected to vCenter red - the host is connected to vCenter and is reporting some kind of problem yellow - the host is connect to vCenter and might be reporting a problem
Boot Time	The date and time when the hypervisor host was last booted.

ESX Performance

Each row in this tab represents a VMware ESXi hypervisor and displays performance information for that host based on the real-time data collected.

Fields	Description
Host-Name	The name of the ESXi hypervisor Note: Usually the DNS name, but sometimes just an IP address
Datacenter	The name of the virtual datacenter that contains this ESXi server belongs
vCenter	The version of vCenter that is monitoring this ESXi host
Cluster	The name of the cluster that contains this ESXi host Note: If the host is not in a cluster, then this field will be blank.
Peak CPU %	The peak CPU used by the ESXi host reported as a percentage of all of the CPU cores running on the host covering the entire duration of the real-time collection Notes: 100% indicates that all CPU cores on the host were completed saturated. This field should fall within a range of 0 - 100%.
Peak CPU (GHz)	The peak CPU used by the ESXi host measured in GHz clock cycles covering the entire duration of the real-time collection
Average CPU %	The average CPU used by the ESXi host reported as a percentage of all of the CPU cores running on the host covering the entire duration of the real-time collection
Average CPU (GHz)	The average CPU used by the ESXi host measured in GHz clock cycles covering the entire duration of the real-time collection
Peak Memory %	The peak memory usage by the ESXi host as a percentage of all of the available RAM memory installed on the host covering the entire duration of the real-time collection Notes: 100% would indicate that at one time during the collection, all of the physical RAM was allocated by the ESXi host
Peak Memory (MiB)	The peak memory used by the ESXi host measured in megabytes covering the entire duration of the real-time collection
Average Memory %	The average memory usage by the ESXi host as a percentage of all of the available RAM memory installed on the host covering the entire duration of the real-time collection Notes: 100% would indicate that at one time during the collection, all of the physical RAM was allocated by the ESXi host
Average Memory (MiB)	The average memory used by the ESXi host measured in megabytes covering the entire duration of the real-time collection
Peak IOPS	The peak IO operations per second (combining read and write operations) for this ESXi host to and from all storage attached to this host for the entire duration of the real-time collection
Average IOPS	The average IO operations per second (combining read and write operations) for this ESXi host to and from all storage attached to this host for the entire duration of the real-time collection
Average Read/Write Ratio	The average read and write ratio as a percentage covering the time records when the IOPS for the ESXi host were >= to the 90th percentile IOPS Notes: This is not the average read/write ratio for the entire duration of the real-time collection. It is only the average for the top 10% of records by IOPS. In other words, when the ESXi host was at it’s busiest, this is the read/write ratio.
Peak Throughput MB/s	The peak (read and write) disk data rate from the ESXi host measured in megabytes per second for the entire duration of the real-time collection
Avg. Throughput MB/s	The average (read and write) disk data rate from the ESXi host measured in megabytes per second for the entire duration of the real-time collection
Peak Read Latency	The peak latency reported in milliseconds for reads issued by the ESXi host for the entire duration of the real-time collection Notes: This latency is calculated at the system level of the ESXi host as an average of operations for each 2 minute sampling period. Therefore, it is possible that an individual datastore might have encountered a higher or lower peak latency for the period for a given operation.
Peak Write Latency	The peak latency reported in milliseconds for writes issued by the ESXi host for the entire duration of the real-time collection Notes: This latency is calculated at the system level of the ESXi host as an average of operations for each 2 minute sampling period. Therefore, it is possible that an individual datastore might have encountered a higher or lower peak latency for the period for a given operation.
Avg. Read Latency	The average latency reported in milliseconds for read operations issued by the ESXi host for the entire duration of the real-time collection
Avg. Write Latency	The average latency reported in milliseconds for write operations issued by the ESXi host for the entire duration of the real-time collection

Host Devices

Each row represents a storage device connected to an ESXi host. The storage device usually is a datastore. It could also be a RDM LUN, backup LUN, or other disk attached to the system.

Field	Description
Server Name	Name of the ESXi host attached to this disk
Device Name	Name of the storage device (usually a datastore name)
Device Type	Either Cluster, indicating that this storage device is shared between more than one ESXi host (and is almost certainly a datastore,) or Local, indicating that this is a disk that only locally accessible by this ESXi host
Capacity (GiB)	The advertised capacity of this device measured in gigabytes Note: This device might be thin provisioned under the hood. In such cases, vCenter and the Optical Prime collection would be unaware of the real provisioned sized of this device.
Free Capacity (GiB)	The unused space on this device measured in gigabytes
Used Capacity (GiB)	The used space on this device measured in gigabytes
Vendor	The manufacturer of the storage device Note: If the device is a datastore that consists of multiple disk extents, the vendor will be for the first disk extent listed in the datastore
Model	The model name of the storage device
Lun Type	One of these possible values: disk, tape, cdrom, communications, enclosure, mediaChanger, opticalDevice, printer, processor, scanner, storageArrayController, unknown, or worm
SCSI Level	The supported SCSI protocol level version for SCSI primary commands (an integer value ranging from 2 - 6)
vStorageSupport	vStorage hardware acceleration support status. If a storage device supports hardware acceleration, the ESXi host can offload specific virtual machine management operations to the storage device. With hardware assistance, the host performs storage operations faster and consumes less CPU, memory, and storage fabric bandwidth.
Datacenter	The name of the virtual datacenter that contains this ESXi host
vCenter	The version of the vCenter system monitoring this ESXi host
VM Count	If this storage device is a datacenter, this is the number of guest virtual machines contained inside this datastore

VMs

Each row in this tab represents a guest virtual machine.

Field	Description
MOB_ID	The Managed Object Identifier string which identifies this guest virtual machine within the scope of the vCenter server monitoring the virtual machine Note: If the project contains data from multiple vCenter servers, then virtual machines with duplicate Managed Object Identifiers are to be expected as these IDs are not globally unique
VM Name	The name of the guest virtual machine as shown in vCenter Note: This name is set by the administrator when the virtual machine is deployed and often is different from the actual host-name of the guest virtual machine
Guest Hostname	The host-name of the guest virtual machine from the perspective of the operating system running on the virtual machine Note: if VMware Tools is not installed or running properly, this field might be blank
IsRunning	TRUE if the virtual machine was running at the time of discovery during the beginning of the collection and FALSE if otherwise
PowerState	One of these values: poweredOn, poweredOff, or suspended
VM OS	The operating system installed on the guest virtual machine Notes: If VMware Tools is installed and running properly, this value should be accurate, but in other cases, this value might be an estimation of the installed operating system.
Disks	The number of virtual disks connected to this guest virtual machine
NICs	The number of virtual network interfaces connected to this guest virtual machine
Virtual CPU	The number of vCPUs provisioned for this guest virtual machine
Provisioned Memory (MiB)	The memory provisioned to this guest virtual machine measured in megabytes
Used Memory (active) (MiB)	The active memory usage for this guest virtual machine as reported during the discovery phase of collection measured in megabytes Notes: The discovery phase occurs at the beginning of a collection and the used memory reported here reflects that specific point in time. Active memory is an estimation calculated by the ESXi host of how much memory is currently being actively used by the guest virtual machine. We recommend that this active memory is used for sizing purposes.
Consumed Memory (MiB)	Amount of guest physical memory consumed by the virtual machine measured in megabytes as reported during the discovery phase of collection Notes: Consumed memory does not include overhead memory. It includes shared memory and memory that might be reserved, but not actually used. VMware recommends that this metric be used for charge-back purposes. We do not recommend that this memory be used for sizing purposes - use active memory instead.
Provisioned Memory (Bytes)	Same as above, measured in bytes
Used Memory (active) (Bytes)	Same as above, measured in bytes
Consumed Memory (Bytes)	Same as above, measured in bytes
Guest VM Disk Capacity (MiB)	The total capacity measured in megabytes of all drives on this guest virtual machine from the perspective of the guest operating system Notes: This value is reported by VMware Tools and will be unavailable if either VMware Tools is not installed or running properly. In the case where this value is not available, it will be a copy of the Virtual Disk Size (MiB) data.
Guest VM Disk Used (MiB)	The used capacity measured in megabytes of all drives on this guest virtual machine from the perspective of the guest operating system Notes: This value is reported by VMware Tools and will be unavailable if either VMware Tools is not installed or running properly. In the case where this value is not available, it will be a copy of the Virtual Disk Used (MiB) data.
Guest VM % Occupancy
Virtual Disk Size (MiB)	The total size measured in megabytes of all virtual disks for this guest virtual machine from the perspective of the ESXi host
Virtual Disk Used (MiB)	The total used capacity measured in megabytes of all virtual disks for this guest virtual machine from the perspective of the ESXi host
VMware Tools Version	The version of VMware Tools installed on this guest virtual machine (if installed at all) Notes: If VMware Tools is not installed, this field will be blank.
Connection State	connected: vCenter has access to this guest virtual machine disconnected: vCenter is currently disconnected to the ESXi host and thus this virtual machine inaccessible: One or more of the virtual machine configuration files are inaccessible. For example, this can be due to transient disk failures. In this case, no configuration can be returned for a virtual machine. invalid: The virtual machine configuration format is invalid. Thus, it is accessible on disk, but corrupted in a way that does not allow the server to read the content. In this case, no configuration can be returned for a virtual machine. orphaned: The virtual machine is no longer registered on the host it is associated with. For example, a virtual machine that is unregistered or deleted directly on a host managed by vCenter shows up in this state.
Template	TRUE if this virtual machine is a template
Unshared (MiB)	Total storage space, in megabytes, occupied by the virtual machine across all datastores, that is not shared with any other virtual machine
Datacenter	The name of the virtual datacenter that contains this guest virtual machine
vCenter	The version of vCenter monitoring this guest virtual machine
Cluster	The name of the cluster that contains this guest virtual machine Notes: If the ESXi host for this virtual machine does not belong to a cluster, then this field will be blank
VM IO Classification	Specifies whether the VM is unique or standard
UUID	A unique identifier for this guest virtual machine Notes: If this guest virtual machine is configured with Fault Tolerance, then the UUID of this machine will match the virtual machine which is it’s fault tolerant partner. Use InstanceUUID for a globablly unique identified that represents this exact instance of this virtual machine
Instance UUID	Instance UUID is generated by vCenter and is unique within a single vCenter (two VMs in different vCenters can have the same Instand UUID). When VMs are failed over, Instance UUIDs are changed. Hyper-V does not have a concept of UUID vs Insatance UUID. Hyper-V has one UUID per VM. The UUID and Instance UUID fields will be the same value.
Datastore	Name of the datastores (can be a comma seperated list) where this guest virtual machine’s virtual disks reside
Host	The name of the ESXi host that contains this guest virtual machine
Guest IP1	The first IP address of this guest virtual machine
Guest IP2	The second IP address of this guest virtual machine
Guest IP3	The third IP address of this guest virtual machine
Guest IP4	The fourth IP address of this guest virtual machine Notes: A guest virtual machine may be configured with any number of IP addresses, but only the first four are shown in this report
Boot Time	The date and time when this guest virtual machine was last booted
Date Provisioned	The date and time when this guest virtual machine was provisioned Notes: This value is not always available
Image Backup	Not Found: indicates that the virtual machine has no custom properties which are typically used by backup software to tag the virtual machine’s backup status Yes: indicates that the virtual machine has one or more custom properties which are typically used by backup software to tag the virtual machine’s backup status. Note, the presence of a custom property does not guarantee that the virtual machine has been backed up recently (or even at any point). However, the presence of custom properties is a strong indicator that the virtual machine was backed up at some point in the past.

VM Performance

This tab is present if you opt to collect individual guest virtual machine performance prior to beginning the collection. Each row represents a single guest virtual machine.

Note: All guest VM performance data is collected every hour at 20 second samples. Average calculations are based on a rolling set of average and peak values are compared against the previous value replacing the value if it is greater.

Field	Description
VM Name	The name of the guest virtual machine as shown in the vCenter Note: This name is set by the administrator when the virtual machine is deployed and often is different from the actual host-name of the guest virtual machine
MOB_ID	The Managed Object Identifier string which identifies this guest virtual machine within the scope of the vCenter server monitoring the virtual machine Note: If the project contains data from multiple vCenter servers, then virtual machines with duplicate Managed Object Identifiers are to be expected as these IDs are not globally unique
Host	The name of the ESXi host
Datacenter	The name of the virtual datacenter that contains this guest virtual machine
Cluster	The name of the cluster that contains this guest virtual machine Notes: If the ESXi host for this virtual machine does not belong to a cluster, then this field will be blank
% of KB/sec	The disk throughput on average that this virtual machine represents as a percentage of all virtual machines.
% of vCPU	The average vCPU usage of this virtual machine as a percentage of all virtual machines' total vCPU usage.
% of Memory	The average active memory used by this virtual machine as a percentage of all virtual machines' total active memory usage.
Peak vCPU %	The maximum observed vCPU usage of this virtual machine based on 24 hours of historical data reported as a percentage. Note: The value ranges from 0 to 100%, but if the VM's upper vCPU limit is set to unlimited or a value higher than the provisioned/reserved vCPU, this value can exceed 100%.
Peak vCPU (GHz)	The maximum observed vCPU usage of this virtual machine reported in CPU clock cycles measured in GHz
Average vCPU %	The average observed vCPU usage of this virtual machine reported as a percentage where 100% equals a single vCPU core
Average vCPU (GHz)	The average observed vCPU usage of this virtual machine reported in CPU clock cycles measured in GHz
Peak Memory %	The maximum active memory usage observed for this virtual machine reported as a percentage of the memory provisioned for this virtual machine Notes: 100% would indicate that at one point during the hour, all of the provisioned memory for this virtual machine was in use. Active memory is an estimation calculated by the ESXi host of how much memory is currently being actively used by the guest virtual machine. We recommend that this active memory is used for sizing purposes.
Peak Memory (MiB)	The maximum active memory usage observed for this virtual machine reported in megabytes Active memory is an estimation calculated by the ESXi host of how much memory is currently being actively used by the guest virtual machine. We recommend that this active memory is used for sizing purposes.
Avg Memory %	The average active memory usage observed for this virtual machine reported as a percentage of the memory provisioned for this virtual machine Notes: 100% would indicate that for the entire hour, all of the provisioned memory for this virtual machine was in use. Active memory is an estimation calculated by the ESXi host of how much memory is currently being actively used by the guest virtual machine. We recommend that this active memory is used for sizing purposes.
Avg Memory (MiB)	The average active memory usage observed for this virtual machine reported in megabytes Active memory is an estimation calculated by the ESXi host of how much memory is currently being actively used by the guest virtual machine. We recommend that this active memory is used for sizing purposes.
Peak IOPS	The maximum observed combined read and write IOPS to and from the virtual disks connected to this virtual machine based on data from the entire collection.
Average IOPS	The average combined read and write IOPS to and from the virtual disks connected to this virtual machine based on data from the entire collection.
Avg. Read/Write Ratio	The average read and write mix to and from the virtual disks connected to this virtual machine based on data from the entire collection.
Max KB/sec	The maximum observed combined read and write data rate measured in kilobytes per second from this virtual machine
Average KB/sec	The average observed combined read and write data rate measured in kilobytes per second from this virtual machine.
Peak Read Latency	The maximum read latency for this virtual machine observed measured in milliseconds
Peak Write Latency	The maximum write latency for this virtual machine observed measured in milliseconds
Avg. Read Latency	The average read latency for this virtual machine observed measured in milliseconds
Avg. Write Latency	The average write latency for this virtual machine observed measured in milliseconds
Peak Latency	The maximum observed latency for any read or write
Peak Read IOPS	The peak read IO operations per second for this guest VM to and from the storage attached to this guest VM
Peak Write IOPS	The peak write IO operations per second for this guest VM to and from the storage attached to this guest VM
Avg Read IOPS	The average read IO operations per second for this guest VM to and from storage attached to this guest VM
Avg Write IOPS	The average write IO operations per second for this guest VM to and from storage attached to this guest VM
Peak Read MB/s	The peak read disk data rate from the gueat VM measured in megabytes per second
Peak Write MB/s	The peak write disk data rate from the gueat VM measured in megabytes per second
Avg Read MB/s	The average read disk data rate from the guest VM measured in megabytes per second
Acg Write MB/s	The average write disk data rate from the guest VM measured in megabytes per second

Custom Attributes

Each row represents a custom attribute that is associated with a virtual machine. Only VMware hypervisors will report custom attributes. Users and third party software products (such as backup software) assign these custom attributes.

Field	Description
Guest VM Name	The name of the guest virtual machine as shown in the vCenter
Custom Attribute	The name of the custom attribute
Custom Content	The value of the custom attribute

ESX Licenses

Each row in this worksheet represents an installed application.

Field	Description
ESX Host	The name of the server, desktop, or directly targeted virtual machine where this application is installed
Software Title	The name of the software package
OS	The operating system of the system

Host Disks

Column	Description
Cluster	Name of the cluster that this hypervisor server belongs to (empty if none)
Host	Name of the hypervisor server
Disk Name	The display name of the disk
Disk Capacity	The capacity of the disk in bytes
Disk Model	The model of the disk
Disk Vendor	The vendor of the disk
SSD	This displays whether there are SSDs

Host Network Adapters

This tab contains a row for each PNIC attached to a hypervisor with the following columns:

Column	Description
Cluster	Name of the cluster that this hypervisor server belongs to
Host	Name of the hypervisor server
PNIC Name	Name of the Network Interface Card
PNIC Speed	Speed of the Network Interface Card
PNIC Vendor	The vendor of the Network Interface Card
PNIC Device Name	The device name of the Network Interface Card