Last change
- Thread starter velo85
- Start date
Not out of the box, no.
You could roll your own using triggers. Not recommended!
Auditing is an add on you can purchase that will audit changes to some/all tables in the database. You can set up policies for who can and can't see the audit information etc.
Change Data Capture is a way of tracking what records have changed, when. Again it's a paid add on. It varies slightly from Auditing. We can go into more detail on these, although there's plenty of documentation out there you can Google. But before making the effort it would help to know more about your requirements, your Progress version etc.
You could roll your own using triggers. Not recommended!
Auditing is an add on you can purchase that will audit changes to some/all tables in the database. You can set up policies for who can and can't see the audit information etc.
Change Data Capture is a way of tracking what records have changed, when. Again it's a paid add on. It varies slightly from Auditing. We can go into more detail on these, although there's plenty of documentation out there you can Google. But before making the effort it would help to know more about your requirements, your Progress version etc.
Rob Fitzpatrick
ProgressTalk.com Sponsor
For last changed table, you could also get this information by parsing your AI files, if you have AI enabled. You might also be able to infer select field changes, depending on which indexes changed. But that isn't a general-purpose technique and it is labour- and I/O-intensive.
You could change your application and schema to add "last change info" fields and update them constantly. Depending on how many fields/tables you are tracking, that could be a lot of changes and a lot of overhead.
As Cringer said the main approaches would be OE Auditing and CDC. Both will impose a performance penalty and increase BI/AI note volume. Both, if not carefully managed, could cause significant growth of your database. Both require a well-defined and implemented data-retention policy.
