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 way to get this information?

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

  • TonySterling's avatar
    TonySterling
    Moderator
    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

    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's avatar
    TonySterling
    Moderator
    11 years ago

    Or use SQL

    USE EnterpriseVaultDirectory

    SELECT MbxArchivingState, count(MbxArchivingState)

    FROM ExchangeMailboxEntry

    GROUP BY MbxArchivingState

     

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

  • AmolB's avatar
    AmolB
    Moderator
    11 years ago

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

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