purge audit policy events from tables

Products

• CA API Gateway

Issue/Introduction

I am trying to purge the policy audit events from the database which could be older by certain number of days.

Wondering if there is already any script to do this for the Layer 7 database tables for the Container L7 version.

Environment

Release : 10.0

Component : API GATEWAY

Cause

There is no script for this for the container version of the gateway 

Resolution

Uploaded a service that be be modified and operate similar to the audit purge scripts used by the appliance gateway.  The uploaded service will purge 4000 records at a time older than 10 days, it will loop 50 times for a total 200,000

There are objects that need to be created (JDBC connection to the SSG DB, the service, then the task)

JDBC connections:  The same parameter used in the YAML file.  (TEST connection)

Create Policy (NOTE: policy type and Tag)

Import XML

Modify JDBC assertions to use the JDBC connection created in step 1 (Choose one connection)

Task -> Global Settings -> Manager Scheduled Tasks

Add