Validating OWSM Message logs from Database

I was doing some RCA for checking the Message Logs of internal and external gateway in OWSM for an older date suppose a week before. For this it was a bit difficult to search the logs for a particular date, so I have used the ORAWSM database schema for this.


The database tables used are: -

1. MessageLogs table where we can filter on a particular ProcessID i.e. SID and a type of log level which we want to select like Request or Response.
2. Logs_Object table, where we can use a join condition based on logid with messagelogs table.

The resultant would be of datatype BLOB i.e. we need to click it and view as a text.