Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Actively delete data that is being logged to a table 1

Status
Not open for further replies.

cterelley

MIS
Mar 11, 2004
11
US
You'll have to forgive me because I'm very new! I have an Access database that receives logs of information from Cisco Secure ACS. This gives me information about users and devices (routers) that authenticate against Cisco Secure. I am then taking this data and running various reports. There are five tables with many fields that I receive from Cisco Secure but there is no way I can restrict certain data from coming through. One of the fields is user_name which receives the user id of the users that are authenticated. The problem is we created a generic AAA user_name for testing and this user is logged thousands of times daily. Is there a way that I can set (within the Access database) the Access tables to reject or delete the AAA entries the second they are logged.
 
How are you getting each record? (How does the data get into the Access database?)
 
I'm unclear of the question but we've configure Cisco Secure to log directly to the Access database. We're not using any CSV (Comma Separated Value) files.
 
In that case, the only way to prevent the information from appearing in the log is to control it on the Cisco side.

You could have a delete query that runs on a timer to delete records from the log table where the user name is AAA, but depending on the time interval you use this could be processor intensive.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
 
I was afraid that it wouldn't be possible to automatically do this on the Access side. Unfortunately there is not way to restrict that on the Cisco side. I guess the timer is kind of a last resort option. I just don't want to tie up that box.
 
If it isn't too much data then you could let it pile up and only run the delete query once a day at some low usage time.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
 
:) That's actually the way I have been doing it up until now. I deleted those entries, purged the database and compacted and repaired the database at around 7AM each morning to keep it reasonable. Thanks for your help Tom!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top