How to show and expand recipient column in the powershell script ?

Hi People,

How can I show and expand the recipient column from the below powershell script result ?

Get-TransportServer | Get-Queue | Get-Message| Select Identity, Subject, FromAddress, Recipients | Sort-Object FromAddress | ft -AutoSize

Open in new window


it is always empty be it one or more than one recipients listed.

Thanks.
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You'll have to convert the array into a string:
Get-TransportServer | Get-Queue | Get-Message|
   Select Identity, Subject, FromAddress,
     @{n = 'Recipients'; e={$_.Recipients -join '; '}} |
   Sort-Object FromAddress |
   ft -AutoSize

Open in new window

0
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks QLemo,

Somehow the result is still blank ? why is that ?
I've tried to stretch the PowerGUI window into both monitor but I can't see the recipients result ?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I can't test ATM. A blank property usually means a typo (the property does not exist), so the first thing to check.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Reread the get-message help, and found that you need -IncludeRecipientInfo to get values in Recipients.
Get-TransportServer | Get-Queue | Get-Message|
   Select Identity, Subject, FromAddress,
     @{n = 'Recipients'; e={($_.Recipients | select -Expand Address) -join '; '}} |
   Sort-Object FromAddress |
   ft -AutoSize

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Senior IT System EngineerIT ProfessionalAuthor Commented:
thanks man !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.