Script to export report performance many machines, exactly vsphere native.

[ByRober]

Hi guys,

I need a script, or any clue to export report performance like vsphere client, but with many machines,

Manually i get perfect information, one per one, but i need to export diferent machines, daily, if you must to do it for 2 machines, is not a problem, extract manually, but when we need

30 machines, this job could be very tediouse.

Many thanks.

[LucD]

Can you be a bit more specific on the entities and performance data you want to capture?

As an intro, you could have a look at my Statistics series (start with Part 1)

[ByRober]

Sorry for delay.

I need script that do exactly the same task like graphical interface vsphere:

On target machine, rigth click, report performance, export performance, Time: from --> to, chart options, cpu, mem, network, size medium, to excel.

When you open excel file is perfect and chart too, but what about if you need do the same work for 10 machines, or 100 machines?

Do you understand me?

Sorry for my horrible english

Thank you very much.

[LucD]

I think I understand, but just to make sure, you want to create a CSV with the performance data for a numble of VMs.

Similar to what you can do under the Performance tab with the Export option?

Which metrics (CPU, memory, disk...) do you want to export this way?

[ByRober]

Sorry, I had to attach the image before,

Yeah, you are right, or from vsphere client, not web, to export diferent machines, not one per one

Export to csv, xls.....

Thanks.-

[LucD]

There are many examples in this community, but a very simple, straightforward example can be found in Multiple VMs performance report in single excel

Is that a good starting point?

Like the author says, you can add additional metrics to the report if needed.

[ByRober]

Hi:

Yes, this was the first script that i found surfing internet, but when i open csv, chart is not done,

but manually by WMware yes.

Any other clue?

Thanks LucD for your helping

[LucD]

That button exports a CSV file, there are no graphs in CSV files.
Do you mean an XLSX file?

[ByRober]

Yes, to XLSX, better ,

[LucD]

Install the Import-Excel module.
On the Export-Excel cmdlet from that module there is a ChartType parameter.

That will create a graph from the data.

Let me know if you need an example