Export request response from audit tables in CA APIM Gateway

Products

• STARTER PACK-7
• CA Rapid App Security
• CA API Gateway

Issue/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

Environment

Release:
Component: APIGTW

Resolution

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;