RE: [IMail Forum] Extract single mailing from logs

[Plato, Art]

Here is a PERL script I wrote just for that type of information.
Hope it helps. I've also attached the instructions for using it.



-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Darin Cox
Sent: Tuesday, August 26, 2008 11:07 AM
To: Imail_Forum@list.ipswitch.com
Subject: Re: [IMail Forum] Extract single mailing from logs

You could probably do this with some sort of grep tool.  I'll leave that
to 
the grep experts.  If we received a request like that, I would import
the 
logs into a SQL database, filter based on from domain, parse out the
queue 
ID from the lines, then reselect all lines with those queue IDs and
export 
the results to a file.

Darin.


----- Original Message ----- 
From: "Dean Lawrence" <[EMAIL PROTECTED]>
To: <imail_forum@list.ipswitch.com>
Sent: Tuesday, August 26, 2008 10:53 AM
Subject: [IMail Forum] Extract single mailing from logs


I have a client that sends a weekly newsletter from my server. There
is a reporting agency that is requesting their mail logs to be able to
verify successful delivery so that they can determine the true number
of subscribers. Does anyone know of a reporting tool or set of grep
scripts that would allow me to extract just those mailings from my
log? I would need the complete email communications (multiple lines)
for each message and the current subscription is about 25,000
addresses. Since Imail does not allow a per domain log file, these
mailings are inter-mingled with al my other client's mail. With this
scenario, is this even something that can be reasonably accomplished?
I'm running 8.22.

Thanks,

Dean

-- 
__________________________________________
Dean Lawrence, CIO/Partner
Internet Data Technology
888.GET.IDT1 ext. 701 * fax: 888.438.4381
http://www.idatatech.com/
Corporate Internet Development and Marketing Specialists

To Unsubscribe: http://imailserver.com/support/discussion_list/
List Archive:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://imailserver.com/support/kb.html


To Unsubscribe: http://imailserver.com/support/discussion_list/
List Archive:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://imailserver.com/support/kb.html

Creates a text file with all of the log entries for the address listed as the 
sender in the named log file.

syntax

emailfrom <logfile> <[EMAIL PROTECTED]>

output e:\imaillog\email-from.txt
#!/usr/bin/perl
#perl2exe_include File/Glob
$emailaddress = $ARGV[1];
open(LOGFILE, <sys$ARGV[0].txt>);
open(OUTPUT,'>email-from.txt');
while(<LOGFILE>) { 
# looking for this:
# 10:13 00:00 SMTPD(0f3c398e00001569) [82.242.60.193] RCPT TO:
# <[EMAIL PROTECTED]>
  if ($_ =~ /(MAIL From)/i and /(\<$emailaddress\>)/i) {
           print OUTPUT $_;
  }
}
close LOGFILE;
close OUTPUT;