If you can handle an Access 2002 DB, I posted a link at the bottom of my webpage: http://it.farmprogress.com/declude/declude.htm
The advantage of the db over the code is you can see the table defs. If you can't handle Access, let me know. ----- Original Message ----- From: "Serge" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 9:34 PM Subject: Re: [Declude.JunkMail] LOG Levels > scott > thanks for the offer > i'm more a foxpro guy > but i suppose the access code will be easy to translate > would appreciate if you email the code > > > ----- Original Message ----- > From: "Scott Fisher" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 05, 2004 2:32 AM > Subject: RE: [Declude.JunkMail] LOG Levels > > > > If you are interested, I have Microsoft Access 2002 VBA code that imports > > the logs into Microsoft Access Databases. Link in a SQL Database instead > > and you can import to SQL I presume. > > This code has been working pretty well for months for me. > > > > I have individual code for the Declude Virus, Declude Junkmail and for > > Spamchk. > > > > As much as the other tools are interesting, nothing beats a database for > > it's in depth ability to look at different data elements. > > > > ---------- Original Message ---------------------------------- > > From: "Mark E. Smith" <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Thu, 4 Nov 2004 15:55:35 -0500 > > > >>We have 4 inbound equal MX servers each with 250-350 per day so we're > >>about > >>the same in net-net load. > >>I started writing a log parsing program that will consolidate the logs and > >>insert them into a central SQL database. > >>That way I'll be able to do a query on a message and debug much easier. > >> > >>The problem right now is loading a 350mb (let alone 1.6GB) file with > >>notepad. :) > >> > >> > >>> -----Original Message----- > >>> From: [EMAIL PROTECTED] > >>> [mailto:[EMAIL PROTECTED] On Behalf Of Glenn \ WCNet > >>> Sent: Thursday, November 04, 2004 3:24 PM > >>> To: [EMAIL PROTECTED] > >>> Subject: Re: [Declude.JunkMail] LOG Levels > >>> > >>> My Declude logs at HIGH range between 1.2 and 1.6 GIGABYTES. > >>> The log for > >>> 11/3 is 1,701,795 KB. > >>> > >>> > >>> ----- Original Message ----- > >>> From: "Mark E. Smith" <[EMAIL PROTECTED]> > >>> To: <[EMAIL PROTECTED]> > >>> Sent: Thursday, November 04, 2004 9:03 AM > >>> Subject: [Declude.JunkMail] LOG Levels > >>> > >>> > >>> > I've always used LOGLEVEL HIGH on my systems but I'm > >>> reconsidering that > >>> > these days since our logs are running 250mb - 350mb. > >>> > > >>> > I use a number of log reports (DLAnalyizer, etc) > >>> > > >>> > If I switch to LOGLEVEL MID will I lose anything in my log reporting > >>> utils? > >>> > > >>> > > >>> > --- > >>> > [This E-mail was scanned for viruses by Declude Virus > >>> (http://www.declude.com)] > >>> > > >>> > --- > >>> > This E-mail came from the Declude.JunkMail mailing list. To > >>> > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>> > type "unsubscribe Declude.JunkMail". The archives can be found > >>> > at http://www.mail-archive.com. > >>> > > >>> > >>> --- > >>> [This E-mail was scanned for viruses by Declude Virus > >>> (http://www.declude.com)] > >>> > >>> --- > >>> This E-mail came from the Declude.JunkMail mailing list. To > >>> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>> type "unsubscribe Declude.JunkMail". The archives can be found > >>> at http://www.mail-archive.com. > >>> > >> > >> > >>--- > >>[This E-mail was scanned for viruses by Declude Virus > >>(http://www.declude.com)] > >> > >>--- > >>This E-mail came from the Declude.JunkMail mailing list. To > >>unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>type "unsubscribe Declude.JunkMail". The archives can be found > >>at http://www.mail-archive.com. > >> > > > > --- > > [This E-mail was scanned for viruses by Declude Virus > > (http://www.declude.com)] > > > > --- > > This E-mail came from the Declude.JunkMail mailing list. To > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > type "unsubscribe Declude.JunkMail". The archives can be found > > at http://www.mail-archive.com. > > > > > --- > [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] > > --- > This E-mail came from the Declude.JunkMail mailing list. To > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > type "unsubscribe Declude.JunkMail". The archives can be found > at http://www.mail-archive.com. > --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com.