question

GaryHuberAdmin-7857 avatar image
0 Votes"
GaryHuberAdmin-7857 asked GaryHuberAdmin-7857 answered

Exchange PowerShell

First, I have not found a GAL report that would give me the below information, so, I think a powershell is what is needed. I do have Exchange Powershell on my system, I can sign in to it and enter commands. What I do need is help with creating a Powershell command string that will show the following and download it in a CSV file.

First Name, Last Name, Mobile Phone, Home Phone, direct reports, Department, Email address, Manager, Title, Office, Street Address, City, State, zip code, Country, Notes, and custom channels 1 through 16


Thank you very much for any help with this.

Regards,

Gary Huber

office-exchange-server-administration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Your question is related with exchange, I will remove network tag and add the corresponding exchange tag. Thank you!

0 Votes 0 ·
GaryHuberAdmin-7857 avatar image
0 Votes"
GaryHuberAdmin-7857 answered

I accept it as an answer

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EricYin-MSFT avatar image
0 Votes"
EricYin-MSFT answered EricYin-MSFT commented

Hi,
It's easy to retrieve AD properties by Get-Mailbox or Get-Recipient but it seems your requirement is most saved in GAL.
However, we can't export information from GAL directly in Powershell.

I would suggest to use Outlook to do this, I'm using Office 365 as an example:

1) Log on to your Outlook desktop (or someone who can view all GALs), find "address book" and select the address book that you want to export, "GAL- username@domain.com" for example, "SHIFT+left-click" the first adress and "SHIFT+left-click" the last address, then right-click "add to Contacts". (My Outlook warns "too many items are selected" in this step by the way, you might have to handle whole GAL in several batches.)
97131-3.png

2) File- Open&Export- Import/Export- Export to a file- Comma Separated Values, find the "Contact" that contains your GAL, save it to a CSV file.
97122-4.png

3) Open the CSV file in excel and select the values you want, some excel skills are needed.



If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



3.png (3.6 KiB)
4.png (22.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I am writing here to confirm with you how the thing going now?
If you need further help, please provide more detailed information, so that we can give more appropriate suggestions.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·
GaryHuberAdmin-7857 avatar image
0 Votes"
GaryHuberAdmin-7857 answered EricYin-MSFT commented

Eric, it worked great. Thank you for the help.

Best regards,

Gary

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Would you accept it as answer so that we can close this thread? thanks in advance.

0 Votes 0 ·