VMware Cloud Community
Rizwan76
Contributor
Contributor

How to create a report to export all host system CPU utilization trend (in %) in a single csv file.

Hello

I am looking all available Host system's CPU utilization trend report (in %) in every 1 hour rollup interval for a day in a single csv file. currently I am able to export one report for one host system. hence I am having 56 host system so I am getting 56 reports and then I have to work 5 hours to consolidate all in a single csv fie.

I am looking report like this..

Host System Name

timestamp

CPU Usage (%)

Memory Usage (%)

vsmep3616

5/15/2016 16:20

2.81

17.69

5/15/2016 16:25

2.64

17.69

5/15/2016 16:30

2.42

17.69

vsmep3617

5/15/2016 16:35

2.97

17.69

5/15/2016 16:40

2.42

17.7

5/15/2016 16:45

2.47

17.69

5/15/2016 16:50

2.87

17.69

Please help me on urgent...

0 Kudos
0 Replies