Ethical Hacking

Learn to find vulnerabilities before the bad guys do! Gain real world hands on hacking experience in our state of the art hacking lab. Course designed and taught by expert instructors with years of penetration testing experience. 12 student maximum in every class. Certification attempt included in every package.
Computer Forensics Training at InfoSec Institute

Gain the in-demand skills of a certified computer examiner, learn to recover trace data left behind by fraud, theft, and cybercrime perpetrators. Discover the source of computer crime and abuse at your organization so that it never happens again. All of our class sizes are guaranteed to be 12 students or less to facilitate one-on-one interaction with one of our expert instructors.




Network Security Snort-Users
[Top] [All Lists]

Re: [Snort-users] SQL to purge alerts over 1 month old?

Subject: Re: [Snort-users] SQL to purge alerts over 1 month old?
Date: Mon, 04 Feb 2008 14:28:30 -0500
On Mon, 04 Feb 2008 12:40:51 -0600, you wrote:

--On Monday, February 04, 2008 09:14:19 -0500 Michael W Cocke 
<cocke@catherders.com> wrote:

The subject line pretty much says it - I'm medium fair at SQL, but I'm
not seeing this;  Anyone know the syntax to flush alerts older than
one month from the alerts DB (MySQL if it matters)?


While it's still up and running, you can download my perl script here.
<http://www.ntsug.org/downloads/archivePlus.tar.gz>

It will do exactly what you describe.  You need to actually read the README 
file.  :-)

Thanks!  Got it.

Mike-
--
If you're not confused, you're not trying hard enough.
--
Please note - Due to the intense volume of spam, we have installed 
site-wide spam filters at catherders.com.  If email from you bounces,
try non-HTML, non-encoded, non-attachments,

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Snort-users mailing list
Snort-users@lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users

<Prev in Thread] Current Thread [Next in Thread>