In vSphere client there's a nice option (Right click server -> Report Performance) to get performance reports in Excel sheet. Is there anyway to do this automatically, like send CPU usage for one week by email once per week? In Scheduled Tasks there's no option for this.
using powercli you can schedule generating performance reports. Refer the following articles.