Solved

Export User Info from Exchange

Posted on 2014-01-13
5
388 Views
Last Modified: 2014-01-23
I would like to export user content from the Global Address book in Exchange 2010 to excel.  If possible, after updating the info, I would like to import it back in.  

Can this be done?  I have access to our Exchange Server but do not know my way around there real well so I can really use some basic help?  Thanks
0
Comment
Question by:snyperj
5 Comments
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39777186
What type of data are you looking to Export? You cannot export data directly from the GAL. The GAL is simply a list of all Exchange objects in the organization. You can however export data like mailboxes, contacts, distribution groups, etc.

You can accomplish this by using powershell. Just tell us what type of data you are looking for and you can use powershell to accomplish this.

Will.
0
 
LVL 18

Expert Comment

by:suriyaehnop
ID: 39777293
You can use Exchange Management Console or Exchange Management Shell to export the user's info:

EMC:

Defined the Maximum Number of Recipient to be Display.
Add/Remove column which contained user information e.g. title, alias and etc
On Action Pane | Export List

EMS:

Get-Mailbox -Result Unlimited | Format-Table Displayname,Alias,PrimarySMTPAddress >C:\Result.csv

Above EMS is to produce list of user's mailbox with CSV file contains information of Displayname,Alias and primarysmtpaddress.

To import/modify bulk properties, you have to do using EMS with preparing the CSV with information that you want to updated such Title

Import-CSV C:\Import.csv | Foreach { Set-Mailbox -Identity $_.Alias -Title $_.Tittle}

To apply above EMS, your CSV file must have following as headers.

Alias
Title

The alias information you do get from the export result.

Certain attributes which unable to apply using Set-Mailbox, such Office or Address, you can bulk modify by using Set-User.

Import-CSV C:\Import.csv | Foreach { Set-User -Identity $_.Displayname -Office $_.Office}
0
 
LVL 7

Expert Comment

by:dsnegi_25dec
ID: 39778292
[PS] C:\Windows\system32>Get-MailboxStatistics -server mbx01 | where {$_.objectClass -eq "Mailbox"} |Sort-object t
otalitemsize -descending |Select-Object displayname,@{Name='Title'; Expression={[String]::join(";",((Get-User -identity
$_.displayname).title))}},@{expression={$_.TotalItemSize.Value.ToMB()}}, itemcount,storagelimitstatus | Export-csv C:\temp\TitleMBXUser.csv
0
 
LVL 12

Accepted Solution

by:
Md. Mojahid earned 500 total points
ID: 39778653
Open exchange console and go to organization  configuration and then go on action panel and click on export list.
0
 

Author Closing Comment

by:snyperj
ID: 39803732
what i did
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Office 365 Login Audit Report 1 35
Exchange 2016 DAG Witness Server 3 37
Lync 2010 4 23
Outlook "You replied to this message" on IMAP accounts 6 14
Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question