Does pyvmonic has the equivalent function of PowerCLI Get-Stat to get statistical information

[nickliu-knife]

Typically, I want to get the average memory usage of a host during a specified period of time.
I can use powercli to run like

Get-Stat -Entity $host -Start 5/5/2020 -Finish 6 /5/2020 -Stat "mem.usage.average"

Wondering I can implement this with pyvmonic.

Thanks.

[sky-joker]

Hi @nickliu-knife

The PyVmomi can be used to get the performance value.
For example, you can get performance value by the following code.

#!/usr/bin/env python
from pyVim.connect import SmartConnect, Disconnect
from pyVmomi import vim, vmodl
import ssl
import atexit
import datetime

host = 'change me to vCenter host name or ipaddress'
username = 'administrator@vsphere.local'
password = 'change me to username password'
esxi_hostname = 'change me to target esxi hostname'
mob = vim.HostSystem

if __name__ == "__main__":
    context = None
    if hasattr(ssl, '_create_unverified_context'):
        context = ssl._create_unverified_context()

    si = SmartConnect(host=host,
                      user=username,
                      pwd=password,
                      sslContext=context)

    atexit.register(Disconnect, si)

    content = si.content

    mob_list = content.viewManager.CreateContainerView(content.rootFolder,
                                                       [mob],
                                                       True)

    for mob in mob_list.view:
        if mob.name == esxi_hostname:
            esxi_obj = mob

    perfManager = content.perfManager

    # The counterId is the specific id that you want to get a performance value.
    # To check the counterId, you can check it by looking the PerfCounterInfo.
    # https://vdc-download.vmware.com/vmwb-repository/dcr-public/b50dcbbf-051d-4204-a3e7-e1b618c1e384/538cf2ec-b34f-4bae-a332-3820ef9e7773/vim.PerformanceManager.CounterInfo.html
    # When vCenter 6.7, the 24 is mem.average.
    metricId = vim.PerformanceManager.MetricId(counterId=24, instance="*")

    # Start time to get the value
    startTime = datetime.datetime.now() - datetime.timedelta(hours=1)

    # End time of getting the value
    endTime = datetime.datetime.now()

    query = vim.PerformanceManager.QuerySpec(maxSample=1,
                                             entity=esxi_obj,
                                             metricId=[metricId],
                                             startTime=startTime,
                                             endTime=endTime)

    result = perfManager.QueryPerf(querySpec=[query])
    for i in result[0].value[0].value:
        print(str(i / 100) + "%")

e.g.

# ./example.py
90.73%
90.5%
90.89%
90.78%
90.76%
91.02%
90.99%
90.92%
91.01%
90.99%

sample: https://github.com/vmware/pyvmomi-community-samples/blob/master/samples/esxi_perf_sample.py