 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
petesquires
Joined: 28 Apr 2011 Posts: 2 Country: United States |
|
2 different audits on 1 table |
|
We have an audit set up for inserts on a table. We use the data from this audit table to report on. I now need to add an audit on changes, but I can't loose the information in the current audit file. How can I set up a new trigger and still keep my old insert trigger?
Thanks, Pete
|
|
Thu Apr 28, 2011 9:10 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
If you are running one of the latest versions, it will keep your existing audit trail table intact. Nothing special is required, just add auditing updates and deletes to the configuration.
If you are running one of the older versions, you will need to archive the audit trail data to a temporary table (use the Data Change Audit/Archive...) menu item and then reinsert it into the new audit trail table using some SQL query like INSERT…SELECT
Tip: names of audit trail tables can be looked up in DB_AUDIT.DATA_AUDIT_TRAIL catalog table.
|
|
Mon May 02, 2011 8:23 am |
|
 |
petesquires
Joined: 28 Apr 2011 Posts: 2 Country: United States |
|
|
|
I am running 4.2.25.2. If this is a "latest version" then when I make my changes, will it just modify the table to include the changes? In other words, will the existing table still be the table used for new information?
Thanks,
|
|
Thu May 12, 2011 7:32 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Yes, this is the latest public version.
|
|
Thu May 12, 2011 10:12 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|