Audit Records - Deleting a single record.

[lynch80516]

Does anyone have experience with deleting a single audit record. I have a model that has auditing enabled and I we found a problem with one of the elements text. We fixed the text, but the original text still is present in the audit record for that element.

What I would like to be able to do is delete that single audit record without completely eliminating all the record logs and starting over.

Any suggestions would be appreciated.

John

[qwerty]

You will probably need to locate the culprit in t_snapshot and delete it with SQL. Pretty much hacking a log which ought to keep changes. Raises the question why you create the audit in the first place. This way you can't trust is. Seems quite odd.

q.

[Geert Bellekens]

I was thinking the same thing.
Why keep an audit log, if you are going to delete specific records from it.
Smells funny

Geert

[lynch80516]

Yes it is weird and unusual. But I'm faced with an issue that I can either delete a single audit record or roll the model back about a year and start over. It's complicated

[qwerty]

Well, I guess you have reasons. FWIW I would not remove the log entry but add a "rollback/undo" action to the log.

q.