SQL Query assistance.

Hello all,

I am looking for adding some info to the below SQL. This is for EV11.0.1CHF3

The query I use is:

Use EnterpriseVaultDirectory

SELECT EME.MbxDisplayName,RT.RetentionCategoryName

FROM [EnterpriseVaultDirectory].[dbo].[JournalingTarget] "JT"

JOIN [EnterpriseVaultDirectory].[dbo].ExchangeMailboxEntry "EME" ON EME.ExchangeMailboxEntryId = JT.ExchangeMailboxEntryId

INNER JOIN [EnterpriseVaultDirectory].[dbo].RetentionCategoryEntry "RT" ON RT.RetentionCategoryID=JT.RetentionCategoryID

Order by EME.MbxDisplayName

 

Which gives me the Journal Mailbox name, and the retentioncategory assigned to it.

I also would like to have on which Exchange server the Journal Mailbox is located.

 

Does any of you know what to add to get that information included in the result of the above query?

 

thanks in advance.

Gertjan