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)
		{
		$row = "" | select Name, Powerstate, Host, MemoryMB
		$row.Name = $vm.name
		$row.Powerstate = $vm.powerstate
		$row.Host = $vm.Host
		$row.MemoryMB = $vm.MemoryMB
		$vmreport += $row
		}
	$datastores = $Vmhost | Get-Datastore
	foreach($datastore in $datastores)
		{
		$row = "" | select Name, FreeSpaceMB, CapacityMB
		$row.Name = $datastore.name
		$row.FreeSpaceMB = $datastore.FreeSpaceMB
		$row.CapacityMB = $datastore.CapacityMB
		$dsreport += $row
		}
	}
	
$vmreport | Export-Csv ".\vmreport.csv"
$dsreport | Export-Csv ".\dsreport.csv"