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

book

Article ID: 16688

calendar_today

Updated On:

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">

 

 

Attachments

1558717105448000016688_sktwi1f5rjvs16ug1.png get_app
1558717103370000016688_sktwi1f5rjvs16ug0.png get_app