Solved

Export User Info from Exchange

Posted on 2014-01-13
5
396 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 19

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

SuperAntiSpyware Licenses Discounted by 25% !

Exclusive offer to Experts Exchange Members!
Buy SuperAntiSpyware License(s) from us and save 25% on the regular purchase price.
- Includes Full SuperAntiSpyware Vendor Support Entitlements
- Your Subscription does not begin until you activate your license
- Buy for your friends

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…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
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…

752 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