Logreport from Sendmail sort by sender and recipients

[Francis J. Lacoste]

On lun, 2002-10-14 at 04:41, Nico Kretschmar wrote:
> hello list,
> 
> I need logreport from sendmail's logfile, where everbody (also
> Manager/Chief Department) can read which mail from user and which mail
> to user with date and time.
> This should be look
> 
> Recipient		 Sender			Date		Time
> Status
> 
> recipient at home.com sender at anywhere.com	14.10.02	10:00:42
> sent
> recipient at home.com sender at anywhere.com	14.10.02	08:00:42
> sent
> 
> Can anybody help me...
> 

This can be easily achieved by writing a custom report specification.
This is easier than it sounds, it's just a matter of writing a XML file 
containing the instructions on what information should appear in the 
report.

You can start by copying a report in $prefix/share/lire/reports/email/

and modifying the content of the  id, title, description elements.

The report operations are contained in the report-calc-spec element. The
following should achieve the kind of report you are interested in:

<lire:report-calc-spec>
 <lire:group>
   <lire:field name="from_domain">
 
   <lire:records fields="from_email to_email time"/>
 </lire:group>
</lire:report-calc-spec>

(The format of that XML file is documented in the developer's manual.
But it might require a little understanding of XML DTDs to make sense of
it...)

If you need more help, don't hesitate to post back! 


Thanks for your interest in LogReport, kind Regards,

Francis J. Lacoste

-- 
Francis J. Lacoste              . .           http://www.logreport.org
/^LogReport$/               . .               flacoste at logreport.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.logreport.org/pipermail/questions/attachments/20021203/9c1a54ca/attachment.bin