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

Products

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

Issue/Introduction

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

Environment

Gateway 8.x, 9.x install 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 May 23, 2017.

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 '%2017-05-23%';

 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKW1AAO" alt="policy_date_2.png" width="719" height="259">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKW2AAO" alt="revision.png" width="453" height="221">