CA API Gateway: Retrieve a list of policies modified on a particular date

Products

• CA API Gateway

Issue/Introduction

How can I retrieve a list of policies that were modified on a given date?

Environment

Gateway 10.x, 11.x installed using a MySQL database

Resolution

This can be done via a MySQL query. The two tables we are concerned with are 'policy' and 'policy_version'. The sample below will retrieve a list of all policies modified on 10/29/2024.

You can customize this date to meet your requirements

select policy.name, FROM_UNIXTIME(policy_version.time/1000) from policy inner join policy_version on hex(policy.goid) = hex(policy_version.policy_goid) where FROM_UNIXTIME(policy_version.time/1000) like '%2024-10-29%';