I am having a heck of a time creating a csv with 3 stats for every cluster in a vCenter. I want to do every 2 hours for the past 30 days. I can gather each stat separately and export them to a csv, but having an issue getting all 3 stats into the same csv. Here are the 3 stats I want: 'cpu.usagemhz.average','mem.usage.average','mem.consumed.average' Here is a sample of what I am looking for (I have taken out my vcenter and clustername:
| VC | Name | Sampletime | Cpumhz | Memusage % | MemConsumed gb |
| vcentername | clustername | 4/4/2021 | 111449 | 29.715 | 1369.216423 |
| vcentername | clustername | 4/4/2021 2:00 | 108259 | 29.731666 | 1370.096066 |
| vcentername | clustername | 4/4/2021 4:00 | 115096 | 29.748333 | 1370.894335 |
| vcentername | clustername | 4/4/2021 6:00 | 98331 | 29.675 | 1367.481006 |
| vcentername | clustername | 4/4/2021 8:00 | 93163 | 29.635 | 1365.609774 |
| vcentername | clustername | 4/4/2021 10:00 | 99407 | 29.623333 | 1365.009445 |
| vcentername | clustername | 4/4/2021 12:00 | 83944 | 29.63 | 1365.297879 |
| vcentername | clustername | 4/4/2021 14:00 | 78432 | 29.633333 | 1365.449091 |
| vcentername | clustername | 4/4/2021 16:00 | 80032 | 29.633333 | 1365.489316 |
| vcentername | clustername | 4/4/2021 18:00 | 81283 | 29.633333 | 1365.462708 |
| vcentername | clustername | 4/4/2021 20:00 | 81105 | 29.658333 | 1366.595776 |
| vcentername | clustername | 4/4/2021 22:00 | 96111 | 29.703333 | 1368.880851 |