Results 1 to 3 of 3

Thread: total message count

  1. #1
    OfMacAndMen is offline Active Member
    Join Date
    Apr 2007
    Posts
    39
    Rep Power
    8

    Default total message count

    Is there a way to get a total of received, send, AV & spam messages? Can we get a report based on a date range also ?

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    You should get the weekly admin report which will detail a lot of these figures, but I have also been taking a look at a report based on date.

    In /opt/zimbra/zmstat is a file called mailboxd.csv which details a whole host of metrics. The three that I have been looking at are :-

    timestamp lmtp_rcvd_msgs lmtp_dlvd_msgs

    Now, I am not quite sure of the exact description of these (hopefully somebody more knowledgeable will jump in) though

    These files then get rolled into a date directory and compressed, so it would be possible to write a perl script to parse these files and generate a report. You could even write the data into a mysql db for historical purposes.

    Will do some more digging.

  3. #3
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Digging for the night has finished but this may be of help to you

    Code:
    su - zimbra
    zmlocalconfig -s | grep mysql | grep logger
    mysql --socket=/opt/zimbra/logger/db/mysql.sock -p
    use the mysql logger password obtained from the grep. Once in mysql run :-

    Code:
    use zimbra_logger
    desc amavis_aggregate
    Some other useful stat tables in there aswell

    You could also take a look at amavis-stats and configure it to point to the zmlogger db. Note tried this so as always proceed with caution.
    Last edited by uxbod; 04-07-2008 at 03:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Re-creating the spam training e-mail account
    By richard-hdd in forum Administrators
    Replies: 21
    Last Post: 03-20-2012, 07:34 AM
  2. Missing Stats Message Count / Message Volume
    By rhostager in forum Installation
    Replies: 15
    Last Post: 12-18-2007, 10:29 AM
  3. Reset Message Count
    By bhickey in forum Administrators
    Replies: 3
    Last Post: 03-13-2007, 09:23 AM
  4. Incorrect New Message Count
    By andreychek in forum Administrators
    Replies: 6
    Last Post: 08-26-2006, 01:07 PM
  5. Message count graph
    By reneanb in forum Administrators
    Replies: 1
    Last Post: 03-17-2006, 09:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •