search cancel

Export request response from audit tables in CA APIM Gateway

book

Article ID: 113701

calendar_today

Updated On:

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;