cancel
Showing results for 
Search instead for 
Did you mean: 

Need SQL query to return last known Exchange server/storage group

Tony_Ace
Not applicable

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

3 REPLIES 3

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

as far as i know, EV doesnt keep track of this.

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

we're you able to sort this out?

JesusWept3
Level 6
Partner Accredited Certified

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"
https://www.linkedin.com/in/alex-allen-turl-07370146