Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > PowerShell

Vista - export-csv question

Reply
 
Old 10-10-2007   #1 (permalink)
blayne


 
 

export-csv question

I am trying to convert a list of IP addresses to a new csv file that has the
host name and ip address in it. I can get the dns name into the csv file but
not the ip address. Here is my code so far;

get-content "C:\ListOfIPs.txt" |
% { [System.Net.Dns]::GetHostByAddress($_) } |
Sort-Object HostName |
Select-Object HostName |
Export-Csv c:\HostNameIPAddress.csv

How do I add another column with the IP address next to the host name into
the destination file?

Thanks

My System SpecsSystem Spec
Old 10-10-2007   #2 (permalink)
Kiron


 
 

Re: export-csv question

Use a calculated property:

get-content c:\ListOfIPs.txt |
% { [System.Net.Dns]::GetHostByAddress($_) } |
Sort-Object HostName | Select-Object HostName,
@{name = 'IP Address';
expression = {"$($_.AddressList)"}} |
Export-Csv c:\HostNameIPAddress.csv -noType

--
Kiron
My System SpecsSystem Spec
Old 10-10-2007   #3 (permalink)
blayne


 
 

Re: export-csv question

That worked, thanks for the help!
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Get-acl and export-csv PowerShell
using export-csv to export to multiple CSV files PowerShell
Export to WAB? Vista mail
export-clixml and compare-object question PowerShell
Export-CliXml/Export-Csv: Change to Export-Object? PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46