We have clusters with more than two resource pools, and each cluster has 20 to 80 esxi hosts.
There are different vm affinity and anti affinity rules for resource pools on same clusters
Every time whenever we need to put some hosts to maintenance for upgrade or troubleshooting, we export host and vm lists, manually checking used cpu&memory, calculating available resources of target hosts, checking drs rules of vm and doing that all in excel to prepare vmotion. Most of the vms are in production with no downtime available.
Is there a way on vcenter to plan these tasks easily? All the needed information is already in vcenter.
Any help or suggestions?