Solved

Export User Info from Exchange

Posted on 2014-01-13
5
386 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

939 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