cancel
Showing results for 
Search instead for 
Did you mean: 

I need a SQL query to find users in provisioning group, exchange

Hi I need a SQL query for EV to find:

 

1.User

2.Exchange server they are on

3. Provisioning Group

 

 

1 Solution

Accepted Solutions
Accepted Solution!

what version of EV and

what version of EV and Exchange? this assumes you have EV 11 and Exchange 2013 because that's what i have in my lab. hope this helps or at least gets you off to the right start.

USE EnterpriseVaultDirectory

SELECT  EME.MbxDisplayName "Mailbox Name",

 PTG.DisplayName "Provisioning Group",

 EMS.ServerName as "Exchange Server"

FROM  EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,

 EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,

 EnterpriseVaultDirectory.dbo.PolicyTargetGroup PTG

WHERE EME.PolicyTargetGroupEntryId = PTG.PolicyTargetGroupEntryId

View solution in original post

4 Replies
Accepted Solution!

what version of EV and

what version of EV and Exchange? this assumes you have EV 11 and Exchange 2013 because that's what i have in my lab. hope this helps or at least gets you off to the right start.

USE EnterpriseVaultDirectory

SELECT  EME.MbxDisplayName "Mailbox Name",

 PTG.DisplayName "Provisioning Group",

 EMS.ServerName as "Exchange Server"

FROM  EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,

 EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,

 EnterpriseVaultDirectory.dbo.PolicyTargetGroup PTG

WHERE EME.PolicyTargetGroupEntryId = PTG.PolicyTargetGroupEntryId

View solution in original post

HI Andrew, I am on EV11 but

HI Andrew,

I am on EV11 but Exchange server is 2010. (lab environment)

 

What would be the difference from the results if I had 2013 vs 2010

 

 

shouldnt be any different.

shouldnt be any different. try the query and let me know how it looks

HI Andrew, It looks

HI Andrew,

It looks good!

 

Thanks for the quick response on this A+