Xref: utzoo comp.mail.sendmail:2777 comp.lang.perl:4293
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!math.fu-berlin.de!opal!unido!infoac!siebeck
From: siebeck@infoac.rmi.de (Wolfgang Siebeck)
Newsgroups: comp.mail.sendmail,comp.lang.perl
Subject: Re: Tools to analyze mail log
Message-ID: <1991Feb27.220654.11280@infoac.rmi.de>
Date: 27 Feb 91 22:06:54 GMT
References: <wi7G7z7x@cs.psu.edu>
Sender: siebeck@infoac.rmi.de (Wolfgang Siebeck)
Organization: RMI Net INFO.box Systems * Aachen * Hamburg * Flensburg
Lines: 45

ehrlich@cs.psu.edu (Dan Ehrlich) writes:

>Does anyone have or know of any tools that will analyze a sendmail log?  I
>am looking for statistics like number of messages/bytes to/from by
>host/user.  If there is something out there that will do this (do not really
>care if its C code, awk, perl, etc) I would appreciate hearing from you.

>Thanks in advance.
>--
>Dan Ehrlich - Sr. Systems Programmer - Penn State Computer Science
><ehrlich@cs.psu.edu>/Voice: +1 814 863 1142/FAX: +1 814 865 3176

I just have finished a packet for this with awk and c routines. If wanted, I
will post (or mail). Sample of output follows:

root~02~03~12~11~576~root~service@infohh~(atreju->infohh)
root~02~03~13~47~722~root~xandi@edicom~(atreju->edicom)
root~02~03~22~07~434~service@infohh~root@atreju~(infohh->atreju)
uucp~02~03~23~45~383~uucp~root~(atreju->atreju)
uucp~02~03~23~45~383~uucp~roof~(atreju->atreju)
uucp~02~03~23~45~383~uucp~root@infoac~(atreju->infoac)

1.  sender/receiver to be charged 
2.  month
3.  day
4.  hour
5.  minute
6.  bytes
7.  sender
8.  receiver
(9. from host -> to hosts)


This output-format can be parsed, inputted to dbm's etc. 

Still under developement.

Regards,
Wolfgang

-- 
*****************************************************************
   ___  ____  ___    _  _ ___ ___   ___ ___ ___     ___ _  _
  /__/ / / /   /    /\ / /__   /   /__//__//   /__//__ /\ /
 / \  /   / __/_   /  / /__   /   /  //  //__ /  //__ /  /