0

Interrogating the History information

Hi - is there a way to interrogate the database history? The history for my Db only goes back 48 hours but I may need to go back further when our auditors come in. If someone could let me know that would be great

 

Thanks

3 replies

null
    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Hi Inspector 99

    I don't rely on this history file at all as it store too much info that I don't want and i have no contrrol over how long it stores etc.

    What I do - Is I use various audit files (ie tables -) that mirror any key tables that I want to keep audit info on. Then every time a user writes/update a record the the system updates (copies) certain key fields plus the user/ and record creation date/time etc. That way I can keep the audit table for as long as I want but in fact I also have a script in global scripts area that checks everytime a user logs on a deletes any records over x years for each audit table. I also set all these audit tables to invisible unless an unlock code it set in the system table.

    Works for me....

    • Inspector_99
    • 2 yrs ago
    • Reported - view

    Thanks for that Mel - I have implemented that this morning!

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Great - glad your sorted :-)

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 197Views