Video Screencast Help

Enterprise vault licenses - how much used

Created: 05 Feb 2013 • Updated: 11 Feb 2013 | 9 comments
wv's picture
This issue has been solved. See solution.

hello all

within enterprise vault admin console is there way we can get utilization report sort of ?

we have reconcilliation going on and i'm asked to prepare report. please help

Discussion Filed Under:

Comments 9 CommentsJump to latest comment

TonySterling's picture

No, not really.  What modules do you use?  If it is mailbox archiving you can check the number of enabled users via SQL.

Use EnterpriseVaultDirectory
Select count(*)
from exchangemailboxentry
where MbxArchivingState = 1

That will give you your number of enabled users.

Here is a technote for reference:

Article URL

How to view a report of disabled, or new user mailboxes from SQL
On occasion a list or report of new, disabled and enabled users may be needed. This can be done from the Vault Directory SQL server. A SQL query can send the results to text or to file Report Viewer .rpt format..

For disabled mailboxes
FROM ExchangeMailboxEntry
Where MbxArchivingState = '2'

For new mailboxes
FROM ExchangeMailboxEntry
Where MbxArchivingState = '0'

For enabled mailboxes
FROM ExchangeMailboxEntry
Where MbxArchivingState = '1'

GertjanA's picture


Be advised that as far as EV is concerned, you pay a license for an active USER mailbox.

Groupmailboxes, or mailboxes that belong to removed users, which are still archive, do not count.

We use the below query to determine the number of active users:

FROM         ExchangeMailboxEntry
WHERE     (MbxArchivingState = 1)
and mbxdisplayname not like 'zz%'
and legacymbxdn not like '%/cn=mbx%'
and mbxdisplayname not like '%removed%'


zz% are mailboxes that belong to service accounts, or the Journal mailboxes

%cn=mbx% are mailboxes having a legacymbxdn starting with mbx, which are group-mailboxes

%removed% in the mbxdisplayname indicates a removed user (ie an inactive mailbox)

We have a huge number of archives, but the actual live archives (ie users) is about half of this.

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS

John Santana's picture

Thanks Gertjan !

I appreciate your SQL sharing here.

Kind regards,

John Santana
IT Professional


Please be nice to me as I'm newbie in this forum.

wv's picture

any official statements on this.

i tried searching articles but couldn't get it.

how do i get licensing faq for ev and from where?

AndrewB's picture

we are symantec partners and are telling you this as authorized resellers and master specialized consultants of EV. if you need further confirmation, you can ask your Symantec rep too.

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner |

wv's picture

andrew i agree with tony and other words. But how do i justify to my seniors . I need to put valid data in front of them. our auditors would ask me how did i calculated number of licenses i needed or i'm using

How to compare it and with what

i thought licensing faq should help. so i was searching for it on google . even our product binaries does not have this guide

Rob.Wilcox's picture

This is a screenshot of *part* of the licensing and support guide that is available to Symantec Partners.

If you need more than that then I'd suggest you go back to the partner that you bought Enterprise Vault from, or Symantec, and ask for the document.

wv's picture

many Thanks rob. which document is this ?

surely would be sort of licensing guides for internals

i think licensing should be transparent to end customers . so they can also be aware of usage, rather then relying on partner

Rob.Wilcox's picture

The document is the licensing and support guide, which is available to partners on a web site which Symantec provide for us.

I agree it should be transparent.

To make it transparent you'd have to 'pester' your local Symantec rep, sales manager, or product manager. (IMHO)