Dear community
I need your help ,I have the below script that pulls out the report Checking for “Dead” paths on HBAs with PowerCLI . I was able to pull out the details but I have problem exporting them in to csv . when I export to csv the datastore property is showing like system.object . could some one please help me. Thanks.
Name : test.esx.com
Device : vmhba8
Cluster : testcluster.
ActiveP : 11
DeadP : 0
StandbyP : 11
Datastore : {DataStore_L1, DataStore_L2, DataStore_L3, DataStore_L4…}
$VMHosts = get-cluster | Get-VMHost | ? { $_.ConnectionState -eq “Connected” } | Sort-Object -Property Name $allresults= @() $datastore = @() foreach ($VMHost in $VMHosts) { write-host “Working on host $VMHost” [ARRAY]$HBAs = $VMHost | Get-VMHostHba -Type “FibreChannel” $datastore = Get-Datastore -VMHost $VMHost foreach ($HBA in $HBAs) { $results = “” | select Name, Device, Cluster, ActiveP, DeadP, StandbyP , Datastore $pathState = $HBA | Get-ScsiLun | ? { $_.Vendor -match “EMC”} | Get-ScsiLunPath | Group-Object -Property state $results.Name = $VMHost.Name $results.Device = $HBA.Device $results.Cluster = $VMHost.Parent $results.ActiveP = [INT]($pathState | ? { $_.Name -eq “Active”}).Count $results.DeadP = [INT]($pathState | ? { $_.Name -eq “Dead”}).Count $results.StandbyP = [INT]($pathState | ? { $_.Name -eq “Standby”}).Count $results.Datastore = [ARRAY]$datastore.name $allresults += $results } } # Display the results in Gridview $allresults | ft -AutoSize # Or export to a CSV $allresults | export-csv -Path C:\Temp\path.csv C:\Temp\path.csv disconnect-viserver -confirm:$false