Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Query Email addresses in AD

Posted on 2009-05-20
6
Medium Priority
?
844 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
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
0
 

Author Comment

by:Y2KBDS
ID: 24432873
Sorry, I am using Exchange 2003.
0
 
LVL 1

Accepted Solution

by:
preshomes earned 1500 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
proxyAddresses=smtp:*

After it finds the results  - Select View > Choose Columns and Select Email Address
0
Industry Leaders: 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!

 
LVL 1

Expert Comment

by:preshomes
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.

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

Expert Comment

by:preshomes
ID: 24433488
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
ID: 24434165
I did the first option and then ran a compare in excel.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn't it be nice if objects in Active Directory automatically moved into the correct Organizational Units? This is what AutoAD aims to do and as a plus, it automatically creates Sites, Subnets, and Organizational Units.
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

577 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