SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in [DB Audit] detailed DML operation      SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic View next topic [DB Audit] detailed DML operation Author Message raffaele Joined: 09 Dec 2009 Posts: 3 Country: Italy [DB Audit] detailed DML operation Hallo I would like to know if Db Audit can report in detail which DML operation a user performed: currently, in the Operation Audit Details I see SEL/UPD/INS/DEL operations altogether, without distinction; instead I would like to have a specific tag pointing to the actual DML operation. Thanks in advance Wed Dec 09, 2009 5:59 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Please try System Audit / Operations Audit Detail report. Wed Dec 09, 2009 8:01 am raffaele Joined: 09 Dec 2009 Posts: 3 Country: Italy SysOp wrote: Please try System Audit / Operations Audit Detail report. Hallo, thank you for reply. As I stated, in the Operation Audit Detail report I see SEL/UPD/INS/DEL operations mixed together. I would like to know if it's possible to log them separately. Wed Dec 09, 2009 9:24 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Which type and version of the database are you auditing? PS. audit logging and reporting are 2 different things. Reports are used to aggregate the information; the format of data presentation on reports may differ from the format of the raw audit data stored in audit trail tables. Wed Dec 09, 2009 9:52 am raffaele Joined: 09 Dec 2009 Posts: 3 Country: Italy I'm auditing a MSSQL2000 SP4 Standard Edition. Actually, I didn't look in details into the actual log, just to the report. Wed Dec 09, 2009 9:56 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 This report is grouped by user/terminal/database/schema object/access time. If you want to see the actual SQL command, please use Reports / System and User Activities Reports / Text of SQL Queries. In case that one doesn't meet your specific requirements too, you can create a custom report to return the required details. Wed Dec 09, 2009 10:47 am 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.