Search someone who left company

Since we are heavily reliant on the Global Address list, you will not be able to locate the user since they've been deleted or hidden:

Here is some information on how to retrieve mail for a user that has been deleted/hidden:

===========================
Need to search mail for user that is Deleted/hidden from Global Address List

Use the following method of searching user mail that is no longer in the global address book in the following steps:

- Open Sql Analyzer
- Highlight the EmailXtender Database
- Enter the following Query:

SELECT * FROM EmailAddress
Where EmailAddress like '%Deleted UserName%'

- Copy the EmailKey returned
- Open calculator
- Paste the EmailKey into the calculator and convert number to Hex
- Enter the Hex Number returned into the Search plugin (Search for words section)

Mail Should be returned
===========================

Hope this helps

wow! great hack. I'll try this.
Thanks for the quick answer!
Regards,
rod

Hi Rod,

Did this work for you?

Hi Anuj

Yes, it worked. Except the convert to hex. This didn't work. But I could resolve it with the address that the SQL Analyzer gave back.

It worked with something like this:
/o=mail-prod/ou=sri administrative group/cn=recipients/cn=huberan52410096

When I use this in the EX Search you can search like this person would still work for the company.

Hope this helps.
Rod

I wrote a support note on it some time back. Search for esg83853 on powerlink.emc.com

If you know what store the user was on, you can also create a new account for the user who has left, then do a search for their email... works..

I was looking all over trying to figure this out, that worked perfectly!

The only thing I noticed was I had to copy the Key from the entry that started "EX:" and not "SMTP:".

Another way this could be done is once you get the query results from SQL (as mentioned in Chris Charlton's post) you can get all smtp/Notes/Exchange addresses for the user and search on all the addresses at once instead of multiple searches as described above.

Lets take for example I return the following 2 results from the sql query

EX:"Mark"
SMTP:"Mark"

Both of these addresses can be placed in the To, From or Mailbox fields seperated by a semicolon. (The semicolon acts as an OR operator)

/o=test/ou=first administrative group/cn=recipients/cn=Mark;Mark@hotmail.com

This method frees up the keyword field for you to utilize keyword searches in the same search. Also no more need to convert decimal to hex.

Thanks Mark!

That is an even easier way to search!

Hi Rod,

we had the same problem. We tried the SQL query. But we didn't find the email. After calling EMC support we found out that you can type the last name of the user in the "Search for the word(s)" field. This returned the emails.

I wrote a Powershell script to read from a text file with the list of users (FirstName LastName). It then querys the database and converts the result to HEX. It then emails the results to whatever address you specify. It makes things much faster when performing larger scale searches with multiple people who no longer with the company. Let me know if anyone would find this useful to post. I would need to go through it and clear out personal information (server names, email addresses, etc.).

Also, I was told that the newest EmailXtender client doesn't require the HEX codes anymore, or has a way of doing the lookup for you. Is that true?