Just a note from our experience: Just because it the message gets delivered to the SMTP server specified by the MX does not mean it was delivered to the user's mailbox. It just means you sent it where they requested. This DOES NOT imply delivery to the enduser - just the end of your responsibility. There are many virus scanners and smtp relays, etc that do not reject the messages and the user's email will later bounce. We get bounces back many days later from SMTP servers that accepted the email and later finally gave up on the delivery attempt.
I would pass this along to the "reporting agency" so that you have disclosed it and that later it does not become a point of disagreement. -Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Cox Sent: Tuesday, August 26, 2008 11:33 AM To: [email protected] Subject: Re: [IMail Forum] Extract single mailing from logs I wouldn't use a loop... just set logic...probably in two passes: one to get all of the queue ids and save them in a temp table, and a second pass to get the lines you want that contain the queue id in them. I've done similar things with other multi-GB logs fairly quickly with no problem. Darin. ----- Original Message ----- From: "Dean Lawrence" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 26, 2008 11:21 AM Subject: Re: [IMail Forum] Extract single mailing from logs Thanks Darin. I was thinking on those lines, but we're talking about 25,000 queue id's to compare the rest of the file with. If I do some type of loop (cursor) or an IN statement, either way your talking about a huge resource pig. This is the biggest hurdle that needs to be tackled. On Tue, Aug 26, 2008 at 11:07 AM, Darin Cox <[EMAIL PROTECTED]> wrote: > 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 > -- __________________________________________ 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
