We created several reports based on the audit database, like users that have not logged in over the last couple of months, reports not used etc.
The reports work fine, however overtime they started containing more and more obsolete items (i.e. users that didn’t login because they are deleted, reports that are no longer there etc).
Is there any way (preserving history) to remove obsolete items from the auditor (i.e. remove all audit history for a user/ report that is no longer there?) Needless to say it would be best if the whole process could be automated
I can see a problem here, because you may want to find out who deleted a specific use or report. When that information has been removed in an automated process this valuable information is now gone.
What I’m trying to say is that I do not know of a way to remove the information , other than removing audit events based on a timestamp (removing info older than, say, 6 months). This process has been described in other posts.
Thanks for the reply, I can see where you are coming from, but there are ways around this (i.e. running the cleanup once a month after running the reports you mention).
In addition, we use EQM for importing/updating/deleting reports which has it’s own auditing so I’m not too worried about delete auditing etc.
I was hoping we could run some script that would compare the audit db against the CMS repository or something…
One option you may have is to put a view on top of the tables and have the rules in the view to filter out the data. However, this will take a bit of time so it depeneds on how important this is to you.
(BOB member since 2007-01-31)