Hi Erin, Yep. I use SecurePlatform FP2 and I have a cronjob scheduled to run after the midnight logswitch. If you want the whole thing I can send it to you but the crux of it is that it runs:
/opt/CPfw1-50/bin/fwm logexport -i logfilename.log -o /pickup/logfile -a which dumps a processed log into /pickup/logfile. The -a tells it to use the accounting log. I then do some more stuff on it to get it into a usable and consistent format (since it seems to vary the order of fields depending on what is in the logfile), tftp it off to the Db server where it is picked up by a scheduled DTS job. If you want further detailed info feel free to mail me off list. Damo > Is anyone importing their Fwall logs to an SQL Server database? Thanks > > > _________________________________________________________________ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > ================================================= > To set vacation, Out Of Office, or away messages, > send an email to [EMAIL PROTECTED] > in the BODY of the email add: > set fw-1-mailinglist nomail > ================================================= > To unsubscribe from this mailing list, > please see the instructions at > http://www.checkpoint.com/services/mailing.html > ================================================= > If you have any questions on how to change your > subscription options, email > [EMAIL PROTECTED] > ================================================= > > ================================================= To set vacation, Out Of Office, or away messages, send an email to [EMAIL PROTECTED] in the BODY of the email add: set fw-1-mailinglist nomail ================================================= To unsubscribe from this mailing list, please see the instructions at http://www.checkpoint.com/services/mailing.html ================================================= If you have any questions on how to change your subscription options, email [EMAIL PROTECTED] =================================================
