04-28-2014 05:12 AM
Hi All,
Is there any way to find out the number of active users in the EV? Currently my customer environment have archives present for all users including the ones which are deactivated. Any way to get this information?
Solved! Go to Solution.
04-28-2014 07:58 AM
So if you want a list you need something like this:
select MbxDisplayName, MbxAlias, MbxArchivingState,MbxExchangeState
from ExchangeMailboxEntry
where MbxArchivingState = 1
MbxExchangeState
0 = NORMAL, 1 = DELETED, 2 = HIDDEN
MbxArchivingState
0 = NONE, 1 = ENABLED, 2 = DISABLED
04-28-2014 05:25 AM
Through Vault Store Usage Report you can find a list of archives with archived items (Active Archives)
http://www.symantec.com/docs/TECH35741
04-28-2014 07:38 AM
Or use SQL
USE EnterpriseVaultDirectory
SELECT MbxArchivingState, count(MbxArchivingState)
FROM ExchangeMailboxEntry
GROUP BY MbxArchivingState
MbxArchivingState
0 = NONE, 1 = ENABLED, 2 = DISABLED
04-28-2014 07:40 AM
So this will give us a list of active archives. We have many active archives in the vault for the user which have been disabled on-prem as they have left the organization. We are trying to find out archives for those users. Any way that can be accomplished. Through a SQl query or something else?
04-28-2014 07:58 AM
So if you want a list you need something like this:
select MbxDisplayName, MbxAlias, MbxArchivingState,MbxExchangeState
from ExchangeMailboxEntry
where MbxArchivingState = 1
MbxExchangeState
0 = NORMAL, 1 = DELETED, 2 = HIDDEN
MbxArchivingState
0 = NONE, 1 = ENABLED, 2 = DISABLED
04-30-2014 06:02 AM
Thanks Tony. That did it.
03-04-2018 03:08 AM
Anyway i can extract email address and alias from this report