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

Article Id: 16688

Status: Published

Updated On: 25-09-2019 05:14

Legacy Id: TEC1125022

Products:

STARTER PACK-7 , CA Rapid App Security , CA API Gateway , CA API Gateway , 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">

1558717105448000016688_sktwi1f5rjvs16ug1.png

Download

1558717103370000016688_sktwi1f5rjvs16ug0.png

Download