Video Screencast Help

ExchangeMailboxEntry table status.

Created: 14 Aug 2013 • Updated: 25 Sep 2013 | 7 comments
This issue has been solved. See solution.

Hello Guys,

Can some on help me with the White paper or Tech Note as what does 'ExchangeMailboxEntry' has in it.

To my understanding it has the info of all the Provisional mailbox entry in it.

Now I need to make some clear understanding of the table and the Exchange Provisional group.

1. When I enable a user for archive his entry is listed in ExchangeMailboxEntry after he is provision.

2. When I delete the users account from AD and MS Exchange but the Inactive Archive stays in Enterprise Vault Server what will happen

a. Will ExchangeMailboxEntry table retain the archive info 

b. Will it remove the infomation after Provison task is completed.

c. If yes then how do I take the count of the Inactive archive with the DN value (so I can check which OU the archive belongs).

I tried the script 

Select * from archive where archivename not in (select a.archivename from archive a,exchangemailboxentry b where a.archivename = b.mbxdisplayname)

Which shows inactive archive but I would like to add the DN vaule coloum from another table, secound I also ran the script as 

Select count (*) from Archive -  which shows me list total archives. (Active and Inactive).

Regards,

Gurmeet Singh Kohli

 

Operating Systems:

Comments 7 CommentsJump to latest comment

AndrewB's picture

i'm not sure i have all the answers for you but could we take one step back and ask what are you trying to accomplish?

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

Mohawk Marvin's picture

You could delete the ExchangeMailboxEntry table and let provisioning rebuild it. Thats a fairly normal process to tidy that table up.

Just take backups, and delete the rows not the actual table :)

JesusWept3's picture

I think the thing he's after is to keep an active record of users, so he *doesn't* want the Table to be cleared

Ben Watts's picture

Just a thought, you may want to clarify the statement to 'delete the table'.

In other words, like JW3 says, CLEAR the table.

 

I know it may seem like common sense, and it was more than likely a typo, to most but better safe than sorry.

JesusWept3's picture

So the user will be removed from provisioning i think after 7 failed attempts and the user no longer exists in Active Directory

Best bet for a query is

SELECT MbxDisplayName, LegacyMbxDN
FROM ExchangeMailboxEntry
WHERE PolicyTargetGroupEntryId IS NULL

This will get you all mailboxes that are no longer provisioned.
However once the entry is deleted from the ExchangeMailboxEntry, you won't have the LegacyMbxDN listed anywhere else, so your best bet maybe to just build your own database and table and simply have it copy the ExchangeMailboxEntry table, 

so Copy the entries in to a #temp table
then loop over them, if the user doesn't exist in the destination table, add the entry
if the user does exist, then simply update the table

Gurmeet Kohli's picture

Hello Guys,

Thank you for your response.

To add to the above questions I would like to know is when does/how does the "ExchangeMailoxEntry" table gets updated.

2. I've deleted the AD + Exchange mailbox account of the user. Now from the 'ExchangeMailoxEntry' table I use the DN value to find the OU location of the inactive Archive.

Right now the count shows only Active archive present.

How do I get the count of the Inactive archives with OU locations.

or which table has the DN vaule listed.

3. Any Tech Note which explains how 'ExchangeMailboxEntry' table works or How it gets updated.

Regards,

Gurmeet Singh Kohli

JesusWept3's picture

Like I said, once the entry is removed from ExchangeMailboxEntry you can't use the LegacyExchangeDN to query EV as the EME table is the ONLY table that contains the DN

The ExchangeMailboxEntry table is updated by the Provisioning task which by default runs once a day automatically or you can set it to run twice a day, and you can also run it manually

To get a list of inactive mailboxes run the following query

SELECT MbxDisplayName, LegacyMbxDN
FROM ExchangeMailboxEntry
WHERE PolicyTargetGroupEntryId IS NULL

SOLUTION