12-07-2011 07:51 AM
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.
Solved! Go to Solution.
12-07-2011 09:06 AM
try this out and let me know how it works for you.
use EnterpriseVaultDirectory
select COUNT(*) from ExchangeMailboxEntry where MbxArchivingState=1
12-07-2011 08:19 AM
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.
12-07-2011 09:06 AM
try this out and let me know how it works for you.
use EnterpriseVaultDirectory
select COUNT(*) from ExchangeMailboxEntry where MbxArchivingState=1
12-07-2011 09:34 AM
Thanks Andrew. It is working fine.