How can I retrieve a list of policies that were modified on a given date?
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>
<Please see attached file for image>