SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in DB Audit Ques      SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic View next topic DB Audit Ques Author Message nmcewan Joined: 26 Mar 2007 Posts: 2 DB Audit Ques Hi, Does this Audit tool allow for automated export to a log file. For example, we need to have all audits for the last 24 hours exported to a log file that can be ftpd. Also I created a sql server user with windows athentication domain/user and I can select to audit ALL(inserts, updates, deletes, all 20,000 tables)against this user. I log into sql server 2005 as this user and make changes to the db and DB Audit is not auditing those changes. Can this app handle a db with 20,000 tables? It seems to seize up just trying to generate the triggers. We will be using this to audit PeopleSoft. thanks Nicole Tue Mar 27, 2007 11:21 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 This can be easily done using DB Audit API. Basically a command line utility is available to export the data in a number of formats. It can be scheduled to run as often as needed using the Alert Center or any other available job scheduler. Tue Mar 27, 2007 1:31 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository 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.