IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Retrieve Old Log Details

  • 1.  Retrieve Old Log Details

    Posted Wed December 07, 2011 05:06 AM

    Hi

    When the logging is directed towards the database, how to access the old logs. Which are the tables that contains these logs.

    Thanks n regards

    Thahir


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Retrieve Old Log Details

    Posted Tue December 13, 2011 10:32 AM

    Hi Thahir. You can find the names of the tables used for audit logging by looking at the table creation scripts. You didn’t mention which version and what type of logging you are interested in, so you’ll have to replace the bits in brackets below with your specifics.

    The scripts, with the table names, are here:

    IS auditing
    <INSTALL_DIR>/common/db/scripts/<YOUR_RDBMS>/iscoreaudit/<LATEST_VERSION>/create

    Process Engine auditing
    <INSTALL_DIR>/common/db/scripts/<YOUR_RDBMS>/processaudit/<LATEST_VERSION>/create

    Regards,
    Michael


    #webMethods
    #Integration-Server-and-ESB