topic Script to export report performance many machines, exactly vsphere native. in VMware PowerCLI Discussions

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

ByRober — Wed, 15 Feb 2017 22:47:27 GMT

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.

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

LucD — Thu, 16 Feb 2017 05:58:35 GMT

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)

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

ByRober — Fri, 17 Feb 2017 15:49:18 GMT

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.

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

LucD — Fri, 17 Feb 2017 17:39:32 GMT

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?

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

ByRober — Fri, 17 Feb 2017 18:14:07 GMT

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.-

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

LucD — Fri, 17 Feb 2017 20:00:11 GMT

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.

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

ByRober — Mon, 20 Feb 2017 17:14:21 GMT

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

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

LucD — Mon, 20 Feb 2017 17:30:17 GMT

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

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

ByRober — Thu, 23 Feb 2017 19:05:47 GMT

Yes, to XLSX, better ,

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

LucD — Thu, 23 Feb 2017 20:11:20 GMT

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