Listing ProxyAddresses on separate

shelleyrosencrantz2760 · 2021-07-21T22:48:59.000Z

I have seen the solution before, in fact I am positive I had it working, but looking at my script now it is not.

I have a script that I pull the user name and I list the ProxyAddresses they have associated. BUT I want to see them on separate lines, not all in one.

Here is my command:

get-aduser $username -Properties proxyaddresses | Select-Object Name,ProxyAddresses

Here is my result:

proxyaddresses : {sip:$username@abcd.com, SMTP:$username@abcd.com, smtp:$username@abcd.mail.onmicrosoft.com}

I want them to list on separate lines. Such as

proxyaddresses :

{sip:$username@abcd.com,

SMTP:$username@abcd.com,

smtp:$username@abcd.mail.onmicrosoft.com}

I think I am just missing something simple.

Thanks in advance.

Neally · 2021-07-21T23:03: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…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

Neally · 2021-07-21T23:19:29.000Z

you can do something like so:

but be advised this is just for the console to LOOK AT, it’s not great if you want to export it to CSV or do further massaging

$u = get-aduser neally -Properties proxyaddresses

[pscustomobject]@{
    Name = $u.Name
    Proxyaddresses = $u.proxyaddresses -join "`r`n"
} | Format-List

717c57c8-8e2a-42ac-a8fb-bb7873c47b02-2021-07-21_18-19-13.png

Neally · 2021-07-21T23:24:38.000Z

ShelleyR:

I think I am just missing something simple

no, you are not, that’s an unusual format.

shelleyrosencrantz2760 · 2021-07-22T19:11:27.000Z

Thank you, I found that solution again, but didn’t try it, remembering it to be much simpler. Should have tested it, thank you for pointing me with confidence.

Neally · 2021-07-22T19:16:08.000Z

What was the solution? There are many ways to accomplish the same thing.

shelleyrosencrantz2760 · 2021-07-22T19:39:42.000Z

I tested your solution, it works as I need it to, so I am using it.

It is one of those things that I have had it before and I clearly remember back when I initially found the solution and thinking “Boy, that was too simple” but then never kept it noted and somehow reverted my script.

Thank you again for your time in answering my questions. Next time I will add my code appropriately.