cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query assistance.

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Regards. Gertjan
1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Something like this?

SELECT EME.MbxDisplayName,RT.RetentionCategoryName, EX.ServerName

 

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

 

JOIN [EnterpriseVaultDirectory].[dbo].ExchangeMailboxStore "EX" ON EX.MbxStoreIdentity = EME.MbxStoreIdentity

Order by EME.MbxDisplayName

View solution in original post

2 REPLIES 2

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Something like this?

SELECT EME.MbxDisplayName,RT.RetentionCategoryName, EX.ServerName

 

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

 

JOIN [EnterpriseVaultDirectory].[dbo].ExchangeMailboxStore "EX" ON EX.MbxStoreIdentity = EME.MbxStoreIdentity

Order by EME.MbxDisplayName

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

10 points for mr. Sterling.

Thanks Tony.

Regards. Gertjan