EV number of the active users

[giuliod]

Hi there

Are you aware on any method (including reporting) to get the number of the current enabled users in EV?  The usage.asp page provides some info, but is shows the total number of archives and I'm interested to see the number of the active users.

Thanks a lot.

[Percy_Vere]

You could try using the number of users that have MBXArchiving state of 1 which means enabled or the LastModified column in the ExchangeMailboxEntry table of the Directory database but obviously that won't indicate whether they are active or not.

[AndrewB · Accepted solution]

try this out and let me know how it works for you.

use EnterpriseVaultDirectory

select COUNT(*) from ExchangeMailboxEntry where MbxArchivingState=1

[giuliod]

Thanks Andrew. It is working fine.