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

Document ID : KB000016688
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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
Answer:

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%';

 

policy_date_2.png

revision.png