export-csv issue

[BobAlbion]

Hello!

I am trying to export-csv the following code, each obvious answer seems to fail or show the too much data, can anyone help?

foreach ($ClusterName in Get-Cluster) {

foreach ($VMHost In Get-VMHost -Location $ClusterName | where {$_.Name -match "rxh*"} | Sort Name ){

write-host $VMHost.Name, $ClusterName, $VMHost.CPUTotalMhz, $VMHost.MemoryTotalMB}}

Thanks

Steve

[LucD · Accepted solution]

Try it like this

$report = @()
foreach ($ClusterName in Get-Cluster) {
	foreach ($VMHost in (Get-VMHost -Location $ClusterName | where {$_.Name -match "rxh*"} | Sort Name)){
		$row = "" | Select Name,ClusterName,CPUTotalMhz,MemoryTotalMB
		$row.Name = $VMHost.Name
		$row.ClusterName = $ClusterName.Name
		$row.CPUTotalMhz = $VMHost.CPUTotalMhz
		$row.MemoryTotalMB = $VMHost.MemoryTotalMB
		$report += $row
	}
} 
$report | Export-Csv "C:\report.csv" -NoTypeInformation

You have to remember that Write-Host sends the data to the console, while the Export-Csv cmdlet picks up what is in the pipeline (when used like this)

____________

Blog: LucD notes

Twitter: lucd22

[BobAlbion]

Thanks! thats perfect