Can Domino 6.5 produce Billing report sorted by OU?

Posted on 2005-04-06
Last Modified: 2013-12-18
We would like to implement Billing so we could charge user's based on their mail usage.  I tried to look for sample Domino Billing report but to no avail.  Would the report be able to provide billing sorted by Department (OU?).  How do I get the billing report for DOmino R6.5 server?
Question by:kamar
    LVL 31

    Accepted Solution

    The billing report is just a view,and can easily be modified, if you have Domino Designer.  Edit the view design.  The first column is "User."  It has a formula of @Name([CN]; UserName). That means take the UserName field, which records the Notes ID name for the session, and use only the [CN] (common name) part.  Change [CN] to [OU1], and it will display (and sort by) the primary OU (e.g., in Kamar/Qwaletee/Experts/Exchange, it would return Experts).

    If you want to drill down through OU's, do as follows:

    1) Click on first column.
    2) Edit -> Copy
    3) Edit -> Paste
    4) Make sure the first column is now highlighted
    5) Change formula to @Name([Canonicalize]; UserName)
    6) In column properties, on first tab, enable the TWSITIE option
    7) Go to the second tab, choose the CATEGORIZED option from the second row of radio buttons
    8) CLick no second column of view -- formula should be original @Name([CN]; UserName)

    Author Comment

    I have never implemented billing before, but Will I be able to use the mail usage information for each users as a basis for billing from the activity database.  Or will it be the log.nsf ?
    LVL 31

    Expert Comment

    The billing report built into the log is a very basic billing system.  When you use the billing add-in task, it actually generates billing information very differently.  Which one were you refering to?  Since you mentioned Sample Billing, I assumed you refered to the one in log.nsf.

    Author Comment

    What I meant was the activity.nsf.  Would it present something that we can use to charge our users on their email usage either via notes session or http (inotes)?
    LVL 31

    Expert Comment


    I beleve it would, but yuo may have to fine tune the way billing works.  You'll have to see if the activity recorded matches what you would like to charge users for.

    - qwaletee

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
    This is an old article, please see an updated version of this article, located here:
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now