• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

SQL cleanup scripts

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> SQL cleanup scripts Page: [1]
Login
Message << Older Topic   Newer Topic >>
SQL cleanup scripts - 14.Jan.2008 9:11:24 PM   
nwigmore

 

Posts: 19
Joined: 28.Nov.2007
Status: offline
Hi there,

Does anyone have or know of a SQL script that cleans out the firewall and proxy tables data that is older than a specified date?

Any help would be great.

thanks.

Nick
Post #: 1
RE: SQL cleanup scripts - 18.Feb.2008 10:39:30 AM   
ChrisF

 

Posts: 5
Joined: 24.Mar.2006
Status: offline
Hi Nick

we had the same "problem" and created a short script on the DB-Server that runs every night and deletes all entries older than x Days (in our example 63 Days):

DELETE FROM WebProxyLog where LogTime < (getdate() - 63) 


Chris

(in reply to nwigmore)
Post #: 2

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> SQL cleanup scripts Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts