• RSS
  • Twitter
  • FaceBook

Exchange Server Forums

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Exchange 2007 User Email Address Lookup

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [Microsoft Exchange 2007] >> General >> Exchange 2007 User Email Address Lookup Page: [1]
Login
Message << Older Topic   Newer Topic >>
Exchange 2007 User Email Address Lookup - 8.Jul.2008 12:31:06 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
I need to get a list of all user mailboxes with a list of email addresses attached to each user.
Is this possible to do using the shell? If so how? or point me to a site or something please.
Any help is appreciated!
Post #: 1
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 12:47:35 AM   
vsin11

 

Posts: 179
Joined: 2.Apr.2007
Status: offline
Try this command from the Exchange power shell:

get-mailbox | select-object name, alias, primarySmtpAddress | Export-Csv
C:\mailboxes.csv -NoTypeInformation


_____________________________

Vinay Pal Singh
http://smarthost.blogspot.com

(in reply to Loris69)
Post #: 2
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:15:12 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
This link teaches you how to play with shell right from basics. (also includes your answer)
http://technet.microsoft.com/en-us/library/bb123533(EXCHG.80).aspx

(in reply to vsin11)
Post #: 3
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:15:15 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
Thanks vsin11,
Thats sort of what i need but i need to get it to display all addresses under each alias and not just the primary smtp address.. is there another keyword which i can use to work along side name, alias and primarySmtpAddress by any chance?

(in reply to vsin11)
Post #: 4
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:19:42 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
Thanks Exchange_Geek!

(in reply to Exchange_Geek)
Post #: 5
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:25:07 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
Get-Mailbox | Format-List -Property Name,Alias,EmailAddresses | Export-CSV C:\EmailAlias.csv

(in reply to Loris69)
Post #: 6
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:31:49 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
hmm i typed that and in the csv is 300 lines of constant
27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c 27c87ef9bbda4f709f6b4002fa4af63c
any ideas why that is happening?

(in reply to Exchange_Geek)
Post #: 7
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:43:08 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
Get-Mailbox | Format-List Name,EmailAddresses | Output-File C:\EmailAlias.txt

If does not work try this

Get-Mailbox -identity Administratior | Format-List Name,EmailAddresses | Output-File C:\EmailAlias.txt

(in reply to Loris69)
Post #: 8
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:49:21 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
The term 'Output-File' is not recognized as a cmdlet, function, operable progra
m, or script file. Verify the term and try again.

(in reply to Exchange_Geek)
Post #: 9
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:52:41 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
Is it possible to use:
Get-Mailbox | Format-Table -Property Name,Alias,EmailAddresses

but to show the whole of the email address
currently it is showing the email column truncated eg. {smtp:bob@hotma...
for example..

(in reply to Exchange_Geek)
Post #: 10
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:54:46 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
Get-Mailbox | Format-List Name,EmailAddresses
 
Try this lets see first of all does it enumerate all the data what you require

(in reply to Loris69)
Post #: 11
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 1:57:52 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
It does do what i require but can the format be Table view eg. Format-Table and still show each record in its entirety ??

(in reply to Exchange_Geek)
Post #: 12
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 2:01:11 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
Yes

(in reply to Loris69)
Post #: 13
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 2:06:53 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
this is what i get:
[PS] X:\>Get-Mailbox -identity bsmith | Format-Table -Property Name,Alias,Email
Addresses

Name                       Alias                      EmailAddresses
----                       -----                      --------------
Bob Smith               bsmith                    {smtp:bsmith@testem...

i cant figure out how to stop it from truncating the email address

(in reply to Exchange_Geek)
Post #: 14
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 2:10:18 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
[PS] X:\>Get-Mailbox -identity bsmith | Format-Table -Property Name,Alias,EmailAddresses -wrap

(in reply to Loris69)
Post #: 15
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 2:17:56 AM   
Loris69

 

Posts: 10
Joined: 8.Jul.2008
Status: offline
Thank you so much, you have been extremely helpful.. I now have what I need!

(in reply to Exchange_Geek)
Post #: 16
RE: Exchange 2007 User Email Address Lookup - 8.Jul.2008 2:19:03 AM   
Exchange_Geek

 

Posts: 1287
Joined: 31.Dec.2006
Status: offline
Your welcome.

(in reply to Loris69)
Post #: 17

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [Microsoft Exchange 2007] >> General >> Exchange 2007 User Email Address Lookup Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Follow TechGenix on Twitter