cancel
Showing results for 
Search instead for 
Did you mean: 

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

JimmyNeutron
Level 6
Partner Accredited

Hi I need a SQL query for EV to find:

 

1.User

2.Exchange server they are on

3. Provisioning Group

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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 4

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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

JimmyNeutron
Level 6
Partner Accredited

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

 

 

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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

JimmyNeutron
Level 6
Partner Accredited

HI Andrew,

It looks good!

 

Thanks for the quick response on this A+