Actively delete data that is being logged to a table 1

[cterelley]

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.

 

[lupins46]

How are you getting each record? (How does the data get into the Access database?)

 

[cterelley]

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.

 

[EBGreen]

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]

 

[cterelley]

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.

 

[EBGreen]

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]

 

[cterelley]

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!