Query Email addresses in AD

Posted on 2009-05-20
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?
Question by:Y2KBDS
  • 4
  • 2

Expert Comment

ID: 24432805
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

Author Comment

ID: 24432873
Sorry, I am using Exchange 2003.

Accepted Solution

preshomes earned 500 total points
ID: 24432982
"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

After it finds the results  - Select View > Choose Columns and Select Email Address
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.


Expert Comment

ID: 24433023
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.

Expert Comment

ID: 24433488
When you go to the site mentioned above be sure to notice that it saves a file in the root of C:

This file will list all of your email addresses.

Hope this helps

Author Comment

ID: 24434165
I did the first option and then ran a compare in excel.

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

Mapping Drives using Group policy preferences Are you still using old scripts to map your network drives if so this article will show you how to get away for old scripts and move toward Group Policy Preference for mapping them. First things f…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

911 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

20 Experts available now in Live!

Get 1:1 Help Now