PowerShell: Export-CSV doesn't write String[] to file

Question

I have a problem with exporting three values to a csv.

This is my code:

Get-WmiObject win32_networkadapterconfiguration -ComputerName $sn.Name | 
Where-Object { 
    $_.Description -like "BASP Virtual Adapter" -or
    $_.Description -like "HP Network Team #1" } | 
Select-Object PSComputername, MACAddress, IPAddress | 
Export-Csv C:\Server_MAC_IP.txt -Force

without the Export-CSV it is displayed correctly, one name one MAC and one IP, but in the txt it says i.e. "Server01","MAC1","System.String[]". Is there a way to get the IP address?

Thanks in advance.

CB. · Accepted Answer · 2013-03-11 11:04:19Z

1

TRY

Get-WmiObject win32_networkadapterconfiguration -ComputerName $sn.Name | 
Where-Object { $_.Description -like "BASP Virtual Adapter" -or $_.Description -like "HP Network Team #1" } | 
Select-Object PSComputername, MACAddress, @{N="IPAddress";E={ $_.IPADDRESS -JOIN ';'}} |
Export-Csv C:\Server_MAC_IP.txt -Force

edited Mar 11, 2013 at 11:04

answered Mar 11, 2013 at 10:53

CB.

61.3k9 gold badges170 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CB. Over a year ago

@IronGibbet Glad to help! The -join is needed in case some NIC have more than one IP configrated.

Collectives™ on Stack Overflow

PowerShell: Export-CSV doesn't write String[] to file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest