Powershell -expandproperty syntax issue

Question

The following Powershell command does not give the results expected:

get-recipient | Select-Object -property DisplayName -ExpandProperty emailaddresses

As per (example 2):

https://msdn.microsoft.com/powershell/reference/5.1/Microsoft.PowerShell.Utility/Select-Object

What am I doing wrong?

Thanks in advance

David (Nobby) Barnes

Answer 1

Hi David,

After consulting our related team, we can achieve your goal via the following “piped-command”:

Get-Recipient |ft Displayname, RecipientType, PrimarySmtpAddress, EmailAddresses –Wrap

Thanks,

Gary

Answer 2

Hi David,

Thanks for your sharing. I have tried the script you provided above and it works find. To see if we can achieve your goal via just one cmdlet or two cmdlets, I am consulting our related team and will post back if I get any updates.

Thanks,

Gary

Answer 3

Hi David,

Thanks for your sharing. I have tried the script you provided above and it works find. To see if we can achieve your goal via just one cmdlet or two cmdlets, I am consulting our related team and will post back if I get any updates.

Thanks,

Gary

Many thanks

David (Nobby) Barnes

Answer 4

Way to go..

That is pretty damned close..

Ace..

Many thanks :)

I know this doesn't expand the 'EmailAddresses' so they are neatly one line each..

But for a quick report for management and the ability to view/search all addresses on the system, this will do nicely..

Many thanks

David (Nobby) Barnes

Answer 5

Hi David,

All Right. If you have any other questions when using Office 365 in future, please feel free to post a new thread in our forum.

Best Regards,

Amanda