Solved

Query Email addresses in AD

Posted on 2009-05-20
6
834 Views
Last Modified: 2012-05-07
I have been given a list of email address in an excel sheet. The sheet includes first, last name and email address.

Part One: Can someone help me to query AD? I want to use the excel sheet to query and see which if any of these email addresses already exist in AD.

Part Two: Can I import an excel sheet of email addresses into an AD DL?
How can this be done?
0
Comment
Question by:Y2KBDS
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:preshomes
Comment Utility
What email system are you using?  If using Exchange 2007 you can use the Exchange Mgmt Shell to query the users with email addresses.  I use this command to get a list of users, mailbox size, and last login time.  This will also export this list to a .csv file on the root of C.

get-mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime | Export-Csv -NoTypeInformation c:\LogonStats.csv
0
 

Author Comment

by:Y2KBDS
Comment Utility
Sorry, I am using Exchange 2003.
0
 
LVL 1

Accepted Solution

by:
preshomes earned 500 total points
Comment Utility
"Open the Acive Directory Users and Computers Management Console
"Right Click on the domain > Select Find
"Select Custom Search in the Find field
"Select the Advanced tab

Type this
proxyAddresses=smtp:*

After it finds the results  - Select View > Choose Columns and Select Email Address
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 1

Expert Comment

by:preshomes
Comment Utility
Also...take a look at the site below.  It contains a vb script that does the same thing. I just ran it on my system and it returned great results.

http://www.suneja.com/blog/2005/09/how-to-export-all-email-addresses-from.html
0
 
LVL 1

Expert Comment

by:preshomes
Comment Utility
When you go to the site mentioned above be sure to notice that it saves a file in the root of C:
c:\proxyaddresses.txt

This file will list all of your email addresses.

Hope this helps
0
 

Author Comment

by:Y2KBDS
Comment Utility
I did the first option and then ran a compare in excel.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now