07-21-2014 04:06 AM
Hi,
I am hoping it will be possible to find out what the last known Exchange server and storage group for each vaulted mailbox was as I am trying to find out what server specific mailboxes were on when they were deleted.
The version of EV we are running is 9.0.3.
Is there a SQL query which will return this for all vaulted mailboxes ?
Thanks,
Tony
07-21-2014 09:06 AM
as far as i know, EV doesnt keep track of this.
08-11-2014 08:49 PM
we're you able to sort this out?
09-26-2014 06:59 AM
Your best bet would be the following query, but it all depends on the records being kept in the ExchangeMailboxEntry table and what not
USE EnterpriseVaultDirectory SELECT EME.MbxDisplayName "Mailbox Name", EME.MbxNTUser "Username", ESE.ExchangeComputer "Exchange Server", EMS.Name "Exchange Database", EME.LastModified "Last Modified Date" FROM ExchangeMailboxEntry EME, ExchangeMailboxStore EMS, ExchangeServerEntry ESE WHERE EME.MbxStoreIdentity = EMS.MbxStoreIdentity AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity ORDER BY "Mailbox Name"