OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
From: Michael Liu (mikekliu_at_vtc.edu.hk)
Date: Fri Feb 14 2003 - 20:10:56 CST

  • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

    Hi,

    I am using MS SQL as database for my ISS RealSecure network sensors and server sensors event
    log.
    In order to control the database size, I need to truncate the ISS tables (events, eventresponse
    etc) every month to clear the logged data.
    However, I also need to keep the last week data in the table for reporting purpose.
    Is there any good way to keep the last week data after truncating the tables? How can I
    temporary select & store the last week data into some temporary tables and insert the last week
    data back to the ISS tables after truncation?

    Following are the tables that I run monthly for clearing the logged data.
    ---- SQL script start --------------------------------
    truncate table events
    truncate table eventresponse
    truncate table eventparams
    truncate table eventupdates
    truncate table eventrawdata
    truncate table eventsrejected
    truncate table eventresponserejected
    truncate table eventparamsrejected
    truncate table eventupdatesrejected
    ---- SQL script end --------------------------------

    Thanks for helping in advance.

    Michael Liu

    _______________________________________________
    ISSForum mailing list
    ISSForumiss.net

    TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo