• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

how many Email addresses do i have on my SBS 2003 server

hi guys,

i was wondering what the best way was to check what and how many email addresses i have on my sbs server. I know if i go to the active directory and click on each users properties i can see the email that the user is connected to but i was wondering if there was a way where i can see everyones email address on one page. thank you
0
MXU2011
Asked:
MXU2011
  • 3
  • 2
  • 2
  • +1
1 Solution
 
nrip_cheemaCommented:
can you count the mailboxes in exchange system manager that will give you some Idea on email address and also on public folders
0
 
Cliff GaliherCommented:
You can do this from the command line, but the command would vary depending on exchange version. What version of SBS are you running?

-Cliff
0
 
vlietjuhCommented:
Take look at the SBS 2003 server resource kit and the csvde
utility. Below is a command string that will export the email address to a
file called email.csv

CSVDE -f email.csv -r "(&(objectClass=user))" -l "sAMAccountName, mail"
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
MXU2011Author Commented:
@ vlietjuh:

can you please provide me with the instructions on doing what you recommneded.
0
 
vlietjuhCommented:
You need to install Windows support tools installed on a Global Catalog server and then run the bwloe command.
1) Start --> Run --> ADSIEdit.msc
2) Expand the "Domain" container.
2) Expand DC=Domain,DC=com.
3) Right click on the OU from where you want to export the SMTP addresses,and select Properties.
4) Look for the property "distinguishedName" and double click on it. Copy the value on it.
5) Paste it in a Notepad.
6) Open a ccommand prompt and type the below command.
csvde -f c:\addresses.csv -d "<paste the value from Notepad>" -r (mailnickname=*) -l mailnickname,proxyaddresses -p subtree

You will have the output in a csv file in the path specified. Open that in excel and do the formating as required.

0
 
Cliff GaliherCommented:
Mail nickname will be incomplete. An account can have only one nickname, but multiple addresses. The appropriate property is proxySMTPaddress, or similar (on a mobile device and don't have immediate access to my motes with the exact property name.) an MSDN search should turn up the exact spelling and a sample query.

-Cliff
0
 
MXU2011Author Commented:
i am running exchange 2003
0
 
vlietjuhCommented:
have you found the csvde utility? (is also present on the w2003 server resource kit cd)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now