performance graph needs to export using powercli

[td_sk]

Hi All,

   I required to share the performance report of some of the VM's  with my client. Currently I am manually generating the report  (  select the VM in  vCenter ==> select the reports ==> export the performance ) . I need to generate this report daily . Please let me know if this can be automated with powercli.

Thanks in Advance.

[LucD]

Yes, that can be done through PowerCLI.

To extract the performance data, you use the Get-Stat cmdlet.

Once you have the performance data, there are several ways to generate graphs from the data.

You can use the charting feature in Excel, see for example my Dutch VMUG: The Statistics Reporting Session post.

But there are many other options available.

One I use quite regularly are the PowerGadgets cmdlets, see for example my Monitor the size of your vDisks post.

Note that PowerGadgets is not a free product.

You could also use Google Charts, MS Charting....

[td_sk]

Hi ,

  Thanks for your reply. But my customer is looking for a report which was generated by vCenter. So please let me know if the vcenter report can be exported.

I am attaching the sample report which I took from Vcenter.

Thanks in advance.

[LucD]

Afaik there are no API to use the vCenter export function.

But you can get the same result with the Get-Stat cmdlet.

Quick question, how did you get the cpu.usagemhz.average values per CPU instance ?

Normally there is only cpu.usage.average per CPU instance

[Wh33ly]

I think vCenters uses  :  https://www.vmware.com/support/developer/vc-sdk/visdk2xpubs/ReferenceGuide/vim.PerformanceManager.ht...

To query the information, wondering how they export it to an excel file