cancel
Showing results for 
Search instead for 
Did you mean: 

Way to find out active users in EV

Mohit_Pal
Level 3

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?

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

6 REPLIES 6

AmolB
Moderator
Moderator
Employee Accredited Certified

Through Vault Store Usage Report you can find a list of archives with archived items (Active Archives)

http://www.symantec.com/docs/TECH35741

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Or use SQL

USE EnterpriseVaultDirectory

SELECT MbxArchivingState, count(MbxArchivingState)

FROM ExchangeMailboxEntry

GROUP BY MbxArchivingState

 

MbxArchivingState
 0 = NONE, 1 = ENABLED, 2 = DISABLED

Mohit_Pal
Level 3

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?

 

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Mohit_Pal
Level 3

Thanks Tony. That did it.

Anyway i can extract email address and alias from this report