Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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 http://www.symantec.com/docs/TECH63686

How to view a report of disabled, or new user mailboxes from SQL
Details:
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
SELECT *
FROM ExchangeMailboxEntry
Where MbxArchivingState = '2'

For new mailboxes
SELECT *
FROM ExchangeMailboxEntry
Where MbxArchivingState = '0'

For enabled mailboxes
SELECT *
FROM ExchangeMailboxEntry
Where MbxArchivingState = '1'

GertjanA's picture

Hello,

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:

SELECT DISTINCT @NrUsers=COUNT(MbxNTUser)
FROM         ExchangeMailboxEntry
WHERE     (MbxArchivingState = 1)
and mbxdisplayname not like 'zz%'
and legacymbxdn not like '%/cn=mbx%'
and mbxdisplayname not like '%removed%'

Explanation:

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
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

SOLUTION
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 | www.trace3.com

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)