$vcenterServerName = $env:vCenterServer
$vcenterUserName = $env:vCenterServerUser
$vcenterPassword = $env:vCenterServerPassword

$wildCardForSearch = "exch01"
$baseFileName = $MyInvocation.MyCommand.Name
$strCSVLocation = "c:\temp\"

Connect-VIServer $vcenterServerName -User $vcenterUserName -Password $vcenterPassword -ea silentlycontinue
$vms = Get-VM | where-object {$_.Name -like $wildCardForSearch}

$stats = @()

foreach($vm in Get-VM){
    $info = Get-Datastore -RelatedObject $vm |
    Select @{N='Host';E={$vm.VMhost.Name}},
    @{N='VMName';E={$vm.Name}},
    Name,
    @{N='Capacity';E={[math]::Round($_.CapacityGB,1)}},
    @{N='Free';E={[math]::Round($_.FreeSpaceGB,1)}}

    $stats += $info
}

$fileSuffix = (get-date).toString('yyyyMMddhhmm')
$fullReportPathWithFileName = $strCSVLocation + $baseFileName + "_" + $fileSuffix + ".csv"
$stats | Export-Csv $fullReportPathWithFileName -NoTypeInformation -UseCulture