cancel
Showing results for 
Search instead for 
Did you mean: 

Enterprise vault licenses - how much used

wv1
Level 3

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

1 ACCEPTED SOLUTION

Accepted Solutions

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Regards. Gertjan

View solution in original post

9 REPLIES 9

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Regards. Gertjan

wv1
Level 3

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
Moderator
Moderator
Partner    VIP    Accredited

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.

wv1
Level 3

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_Wilcox1
Level 6
Partner

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.

Working for cloudficient.com

wv1
Level 3

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_Wilcox1
Level 6
Partner

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)

Working for cloudficient.com

John_Santana
Level 6

Thanks Gertjan !

I appreciate your SQL sharing here.