Layer7 API Management

Expand all | Collapse all

Retrieve Policies that are changed

Jump to Best Answer
  • 1.  Retrieve Policies that are changed

    Posted 07-19-2017 06:00 PM

    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.



  • 2.  Re: Retrieve Policies that are changed
    Best Answer

    Posted 07-20-2017 09:05 AM

    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



  • 3.  Re: Retrieve Policies that are changed

    Posted 07-20-2017 11:48 AM

    Thanks Joe.



  • 4.  Re: Retrieve Policies that are changed

    Posted 07-20-2017 09:12 AM

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

     



  • 5.  Re: Retrieve Policies that are changed

    Posted 07-20-2017 11:48 AM

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