How to export this script to csv

FrenchToast · 2019-06-14T00:24:51.000Z

Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$.EmailAddresses |Where-Object {$.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}}

Not familiar with looping arrays and how to export the result to powershell.

I’m more familiar with returning information that I need from exchange and AD and just being able to Export-CSV c:\test.csv -NoTypeInformation after my command. Not having to much luck here.

Neally · 2019-06-14T00:32:06.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2019-06-14T00:33:06.000Z

What have you tried?

maybe like so

$result = Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} 

$result | export-csv "c:\result.csv" -NoTypeInformation

patrickdeno2 · 2019-06-14T11:46:18.000Z

Neally’s answer, as per usual, is probably the best one, especially if this snippet is part of a longer script, since it puts everything into a variable for later use. However, if this is just an educational exercise, you could just pipe everything directly to the CSV as well, like so:

Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | export-csv "c:\result.csv" -NoTypeInformation

Either way would probably work, depending on what you want your result to be or how you want to use the data.