Through this script you will get the all VM report from require Datacenter .
VM report powerCLI script :

Open the PowerCLI icon (Run as Administrator) and you can execute commands manually, run scripts manually or automate your scripts with Task Scheduler (see below).
Clear-Host
$c=1
$total = 0
$dcs = get-datacenter
foreach($dc in $dcs){
$clusters = get-datacenter $dc | get-cluster
foreach($cluster in $clusters)
{
$cntesx = (Get-Cluster $cluster | Get-VMHost).Count
$vhosts = Get-Cluster $cluster | Get-VMHost
foreach($vhost in $vhosts)
{
$vms = (Get-Vmhost $vhost | get-vm ).Count
Write-Host "$dc ----> $c. $vhost has $vms VMs"
$c++
$total = $total + $vms
}
Write-Host "========================================="
Write-Host " Total Vms in Cluster : $cluster = $total" -f green
Write-Host "========================================="
}
}
Thanks hope you like it.
Rajiv Pandey.