Using audit records to trace administrative actions

About this task

Audit records are helpful for proving that activities occurred at a stated time between partners. Audit records enable tracing creations and deletions to routing channel templates and routing channels. The records indicate when and what changed and who made the changes. By default, audit records are turned on. To view and use audit records:

Procedure

  1. Select Tools > B2B Console > Admin > Operations > System > Support Tools > SQL Manager.
  2. Type the following:
    select * from YFS_AUDIT  
    
  3. Click Execute to view all audit records.
  4. Or, select the tables and columns you are interested in, for example:
    select TABLE_NAME, OPERATION, AUDIT_XML, CREATETS, 
    CREATEUSERID, MODIFYTS, MODIFYUSERID from YFS_AUDIT where 
    TABLE_NAME = 'FG_ROUTCHAN_TMPL' or TABLE_NAME = 'FG_ROUTCHAN'