10-20-2015 12:32 PM
Hi I need a SQL query for EV to find:
1.User
2.Exchange server they are on
3. Provisioning Group
Solved! Go to Solution.
10-20-2015 12:52 PM
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
10-20-2015 12:52 PM
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
10-20-2015 01:26 PM
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
10-20-2015 01:29 PM
shouldnt be any different. try the query and let me know how it looks
10-20-2015 01:36 PM
HI Andrew,
It looks good!
Thanks for the quick response on this A+