Layer7 API Management

Is there a way to programmatically (API or script or mysql query) get a list of all policies changes on a given date?

I am trying to find out what all policies are changed after a deployment using GMU in 9.2.

Thanks.

Hi Justus,

This can be done with MySQL. The two tables we are concerned with are 'policy' and 'policy_version'

Something along these lines:

select policy.name, FROM_UNIXTIME(policy_version.time/1000) from policy inner join policy_version on hex(policy.goid) = hex(policy_version.policy_goid);

Regards,

Joe

Thanks Joe.

Specific date search for a policy revised on May 23, 2017:

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

Thanks Joe. This is exactly what I am looking for.