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


Email Address Already in use

Posted on 2004-09-23
Medium Priority
Last Modified: 2012-06-27
Hi all,

Yet another Question, I would like to know how to find out who is actually using a particular email address in the organisation.

Is there a way to find this info quickly rather than going thru everyones email aliases??


Question by:SynsealIT
  • 2
LVL 17

Accepted Solution

Microtech earned 60 total points
ID: 12133183
Hi SynsealIT,
copy this text into a nodepad file and save as .VBS

Const Writable      = 2

Set objFSO           = CreateObject("Scripting.FileSystemObject")
Set objLog          = objFSO.OpenTextFile("c:\proxydump.csv", Writable, True)
Set cn               = CreateObject("ADODB.Connection")
Set cm               = CreateObject("ADODB.Command")
Set rs               = CreateObject("ADODB.RecordSet")

With cn
     .Provider     = "ADsDSOObject"
     .Open "Active Directory Provider"
End With

Set cm.ActiveConnection = cn

strDomainDN          = InputBox("Please Enter the Servername and Domain DN. " & vbCrLf & " Example: Myserver/DC=test,DC=lab ")

cm.CommandText = "<LDAP://" & strDomainDN & ">;(&(objectCategory=user)(proxyAddresses=*));distinguishedName,mail,proxyAddresses;subtree"
cm.Properties("Page Size") = 1000

Set rs               = cm.Execute

While Not rs.EOF

     On Error Resume Next
     strUserDN     = rs.Fields("distinguishedName")
     strProxyAddress = rs.Fields("proxyAddresses")

     objLog.Write strUserDN
     objLog.Write ","
     For Each Item in strProxyAddress
          strTempAddr = Item
          objLog.Write Item & ";"

     objLog.Write vbCrLf


msgbox "Export Complete to c:\proxydump.csv"

this will create a csv file on your c drive with all smtp addresses in your domain.

Hope This helps

Author Comment

ID: 12134802
Thats mint matey!!! Bril :) only thing i it is a public folder i believe that has this alias. Is there any mods i can make to script that will allow this???

Thanks again

LVL 104

Expert Comment

ID: 12135710
I tend to just type the full email address in to Outlook's To: line and then wait to see what Outlook resolves it to.

LVL 17

Expert Comment

ID: 12199154

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

This article describes Top 9 Exchange troubleshooting utilities that every Exchange Administrator should know. Most of the utilities are available free of cost. List of tools that I am going to explain in this article are:   Microsoft Remote Con…
Steps to fix “Unable to mount database. (hr=0x80004005, ec=1108)”.
This video discusses moving either the default database or any database to a new volume.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

580 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