Forum Discussion

Mohit_Pal's avatar
Mohit_Pal
Level 3
11 years ago

Way to find out active users in EV

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 ...
Enterprise Vault
Evaluating
Information Governance
Monitoring
Performance
Reporting
Windows Server (2003-2008)
  • TonySterling's avatar
    TonySterling
    11 years ago

    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's avatar
Mohit_Pal
Level 3
11 years ago

Thanks Tony. That did it.

  • sathishexchange's avatar
    sathishexchange
    Level 3
    7 years ago

    Anyway i can extract email address and alias from this report