unable to get the CSV output

[ganapa2000]

Hi,

I am unable to get the CSV output for below as I the csv output shows

Length

"24"

"36"

Please help

$dCenter = "MyDC"
$cluster = "Compute"
$clusterInfo = Get-Datacenter -Name $dCenter | get-cluster $cluster
$vmHosts = $clusterInfo | get-vmhost | select -ExpandProperty Name
$RDMNAAs = $clusterInfo | Get-VM | Get-HardDisk -DiskType "RawPhysical","RawVirtual" | Select -ExpandProperty ScsiCanonicalName -Unique
$RDMNAAs | Export-CSV -Path ".\RDMs.csv" -NoTypeInformation -UseCultur

[LucD]

Did you try with

Select -Property ScsiCanonicalName -Unique

instead of

Select -ExpandProperty ScsiCanonicalName -Unique

[ganapa2000]

LucD,

I tried as below, it worked. but I dont need header. how can I get the output without header in CSV

Select -Property ScsiCanonicalName -Unique

[LucD · Accepted solution]

Try something like this

$RDMNAAs = $clusterInfo | Get-VM | Get-HardDisk -DiskType "RawPhysical","RawVirtual" | Select -Property ScsiCanonicalName -Unique
$RDMNAAs | 
ConvertTo-Csv -NoTypeInformation |
Select-Object -Skip 1 |
Set-Content -Path ".\RDMs.csv"

[ganapa2000]

That worked perfect :)...Thank you very much