See if this works for you
$Creds = Get-Credential -Message
"Enter username and password" -ErrorAction SilentlyContinue
$vCenters = (Get-Content "C:\VC.txt")
$report = foreach ($vCenter in $vCenters) {
Connect-VIServer $vCenter -Protocol https -Credential $Creds | Out-Null
Get-Cluster -Server $vCenter -PipelineVariable cluster |
ForEach-Object -Process {
Get-Datastore -RelatedObject $cluster |
where{$_.FreeSpaceGB -gt 8GB -and $_.DatastoreBrowserPath -notcontains "*local-storage-1"} |
Select @{N='vCenter';E={$vCenter}},
@{N='Cluster';E={$Cluster.Name}},
@{N='Datacenter';E={$_.Datacenter.Name}},
@{N='Datastore Browser Path';E={$_.DatastoreBrowserPath}},
@{N='Datastore Name';E={$_.Name}},
@{N='Datastore Capacity';E={$_.CapacityGB}},
@{N='Datastore Free Space';E={$_.FreeSpaceGB}}
}
}
$report | Export-Csv -Path .\Output.csv -Append -NoTypeInformation -UseCulture
