SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
2 different audits on 1 table

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
2 different audits on 1 table
Author Message
petesquires



Joined: 28 Apr 2011
Posts: 2
Country: United States

Post 2 different audits on 1 table Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
petesquires



Joined: 28 Apr 2011
Posts: 2
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Yes, this is the latest public version.
Thu May 12, 2011 10:12 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.