Ok. Use this one then in conjunction with the other. Use emailfrom to
get the message ID then use specificemail to get all of the log output
pertaining to that email. I have written many tools to gleen info from
the logs. These are just a few. Hope this helps.
Art.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Darin Cox
Sent: Tuesday, August 26, 2008 12:10 PM
To: [email protected]
Subject: Re: [IMail Forum] Extract single mailing from logs
Hi Art,
I don't think this does everything. I believe he needs all lines for
the
message in the log, not just the lines with the FROM address on it.
Darin.
----- Original Message -----
From: "Plato, Art" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, August 26, 2008 11:55 AM
Subject: RE: [IMail Forum] Extract single mailing from logs
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: [email protected]
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: <[email protected]>
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
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
Syntax for specifictext.exe
specificemail <date(i,e, 0826)> <Email ID you are looking for. (NOTE this
program is not case sensitive)>
The output file is specific-email.txt
#!/usr/bin/perl
#perl2exe_include File/Glob
$messageid = $ARGV[1];
@openfile=<*$ARGV[0].txt>;
print "@openfile\n";
open(OUTPUT,'>specific-email.txt');
foreach $file (<*$ARGV[0].txt>) {
open(LOGFILE, $file);
while(<LOGFILE>) {
# looking for this:
# 10:13 00:00 SMTPD(0f3c398e00001569) [82.242.60.193] RCPT TO:
# <[EMAIL PROTECTED]>
if ($_ =~ $messageid) {
print OUTPUT $_;
}
}
}
close LOGFILE;
close OUTPUT;
