Results 1 to 3 of 3

Thread: Daily Message Report

  1. #1
    Join Date
    Oct 2009
    Posts
    13
    Rep Power
    5

    Default Daily Message Report

    Hi,

    I'm interested in generating a daily report that displays the number of messages sent per user each day, which will help us identify accounts that may be compromised and spamming.

    I thought a simple script that grepped and counted "from=<$username" from the mail logs would work but I've run into a hitch. When a user sends a message, the mta accepts it into the queue, but then requeues it and relays it through the content filter. Since it's queued twice, it shows up as two separate messages in the logs, and simply grepping and counting "from=<$username" returns a misleading value. (Note that spam with the sender address spoofed as someone in the domain will cause this as well).

    I modified the script to handle this but it's much too slow. Does anyone have any suggestions on how to accomplish this? I thought I saw that there was a Zimbra command that actually generated these types of reports but I can't seem to find it now.

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    The admin account should be receiving a daily report that provides email statistics. Have a look at that job for some ideas about how to generate a new report, it's based on pflogsumm.

    [edit]Note that pflogsumm is introduced in the 6.x release of Zimbra but it does work on earlier releases.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Oct 2009
    Posts
    13
    Rep Power
    5

    Default

    Thanks phoenix.Turns out these reports were never being mailed because the mailbox server that runs them doesn't have an mta installed. I'm setting up a work around for that, though. Looks like they'll have a lot of useful info in them!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 'Couldn't access Yahoo! Zimbra Desktop server"
    By chirag1 in forum Error Reports
    Replies: 37
    Last Post: 06-12-2011, 05:14 PM
  2. After update 5.16 to 6.0, Daily Mail Report is empty.
    By opc31199 in forum Administrators
    Replies: 7
    Last Post: 10-05-2009, 09:31 PM
  3. [SOLVED] Zimbra desktop slowed down the system
    By hvle in forum General Questions
    Replies: 5
    Last Post: 03-23-2009, 05:32 PM
  4. Emails bouncing with "Error Text: 401,'null'"
    By sholden in forum Zimbra Connector for Outlook
    Replies: 27
    Last Post: 08-20-2008, 04:59 PM
  5. [SOLVED] Mailserver down when send file attach of 50Mb
    By ZMilton in forum Administrators
    Replies: 20
    Last Post: 04-10-2008, 11:44 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
  •