08-14-2013 07:41 AM
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
Solved! Go to Solution.
08-15-2013 04:20 AM
08-14-2013 08:43 AM
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?
08-14-2013 09:33 AM
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 :)
08-14-2013 09:33 AM
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
08-14-2013 09:34 AM
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
08-15-2013 01:31 AM
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
08-15-2013 04:20 AM
08-15-2013 07:25 AM
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.