Highlighted

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?

1 Solution

Accepted Solutions
Accepted Solution!

So if you want a list you

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

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post

6 Replies

Through Vault Store Usage

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

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

Or use SQL USE

Or use SQL

USE EnterpriseVaultDirectory

SELECT MbxArchivingState, count(MbxArchivingState)

FROM ExchangeMailboxEntry

GROUP BY MbxArchivingState

 

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

For the best O365 Reporting Solution click here Radar-Reporting

So this will give us a list

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?

 

Accepted Solution!

So if you want a list you

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

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post

Thanks Tony. That did it.

Thanks Tony. That did it.

Re: Thanks Tony. That did it.

Anyway i can extract email address and alias from this report