Forum Discussion

wv1's avatar
wv1
Level 3
12 years ago

Enterprise vault licenses - how much used

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

Enterprise Vault
Information Governance
  • GertjanA's avatar
    GertjanA
    12 years ago

    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.

  • TonySterling's avatar
    TonySterling
    Moderator
    12 years ago

    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 avatar
    GertjanA
    Moderator
    12 years ago

    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.

  • wv1's avatar
    wv1
    Level 3
    12 years ago

    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 avatar
    AndrewB
    Moderator
    12 years ago

    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's avatar
    wv1
    Level 3
    12 years ago

    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's avatar
    Rob_Wilcox1
    Level 6
    12 years ago

    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.

  • wv1's avatar
    wv1
    Level 3
    12 years ago

    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's avatar
    Rob_Wilcox1
    Level 6
    12 years ago

    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)