Export request response from audit tables in CA APIM Gateway

Document ID : KB000113701
Last Modified Date : 13/09/2018
Show Technical Document Details
Introduction:
In policies, using "Audit Messages in Policy" assertion with "always" options to save request/response.
The SQL query below will export request/response from audit tables in a date range
Instructions:
Here is an example to show the request/response for 2018-09-13, 
select b.name, FROM_UNIXTIME(b.time/1000) time, uncompress(a.request_zipxml) request, uncompress(a.response_zipxml) response from audit_message a, audit_main b where a.goid=b.goid and b.time between UNIX_TIMESTAMP('2018-09-13')*1000 and UNIX_TIMESTAMP('2018-09-14')*1000;