Add-PSSnapin Vmware.VimAutomation.Core -ea silentlycontinue
Write-Host -ForegroundColor Yellow "This script will generate a summary report of Hosts and VMs"

$vc = Read-Host "Enter VC"

connect-viserver $vc

$vmhosts = Get-Vmhost
$vmreport = @()
$dsreport = @()

foreach($Vmhost in $vmhosts)
	{
	$vms = $Vmhost | get-vm
	foreach($vm in $vms)
		{
		$datastore = $vm | get-datastore
		$row = "" | select Name, Powerstate, Host, MemoryMB, DSName, DSFreeSpaceMB, DSCapacityMB
		$row.Name = $vm.name
		$row.Powerstate = $vm.powerstate
		$row.Host = $vm.Host
		$row.MemoryMB = $vm.MemoryMB
		$row.DSName = $datastore.name
		$row.DSFreeSpaceMB = $datastore.FreeSpaceMB
		$row.DSCapacityMB = $datastore.CapacityMB		
		$vmreport += $row
		}
							
	}
	
$vmreport | Export-Csv ".\vmreport.csv"