Hi guys

I have a problem.  I need to compile a list of all email addresses in use at my organisation.  Now I can easily get the primary email address from AD but the ones where I have a problem is where a user has a few alternate email addresses.

I have found the field and I can access pull it from AD with the following query:

get-qaduser "joe bloggs" -includeallproperties | select proxyaddresses

This returns all the alternate addresses in the following form:

{smtp:joe.bloggs@companyA.com, smtp:j.bloggs@companyA.com}

I need to be able to break that object down so my end result a spreadsheet that looks like:

joe.bloggs@companyA.com

j.bloggs@companyA.com

Does anyone have any ideas how this might be done?

Thanks.

Lee

...where {$_ -like "smtp:*"} | foreach {$_.substring(5)}

I would make some chnages to your command:

1. Don't use -includeallproperties when all you need is just the proxyaddresses property, use -includedProperties instaead (-ip for short).

2. To get ALL user objects, use the '-sizeLimt 0' parameter.
3. Use an ldap query to filter just the objects that has a proxyaddresses value.


PS > get-qaduser -sizeLimt 0 -ldap '(proxyaddresses=*)' -ip proxyaddresses | select -expand proxyaddresses | where {$_ -notmatch "x" -and $_ -like "smtp:*"} | foreach {$_.substring(5)}

If the above command still generates the '..nothing to expand' error then you can add a where-object filter to pass on none null proxyaddresses properties or just add '-errorAction silentlyContinue' to select-object to supress the error:

PS > get-qaduser -sizeLimt 0 -ldap '(proxyaddresses=*)' -ip proxyaddresses | where {$_.proxyaddresses} | select -expand proxyaddresses | ...

- or -


PS > get-qaduser -sizeLimt 0 -ldap '(proxyaddresses=*)' -ip proxyaddresses | select -expand proxyaddresses -ea silentlyContinue | ...

Or a combination of both ;-)