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: <Imail_Forum@list.ipswitch.com> 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: <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 > -- __________________________________________ 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
