AnsweredAssumed Answered

How to extract declared clusterwide property names form policy XML

Question asked by mpa29 on Jul 11, 2017
Latest reply on Oct 12, 2017 by Ben.Deutsch

Hi All,


I have a requirement to pull few declared cluster wide properties names from policy.

 I am able to retrieve the policy XML with the below query, but the cluster wide declaration values are encrypted in the output XML. Could you please help me to find out the declared cluster wide property names from the policy XML.



select p.xml from policy p INNER JOIN published_service s ON p.goid = s.policy_goid where s.routing_uri like '%/test%';



| <?xml version="1.0" encoding="UTF-8"?>
<wsp:Policy xmlns:L7p="" xmlns:wsp="">
    <wsp:All wsp:Usage="Required">
            <L7p:Base64Expression stringValue="JHtnYXRld2F5LmFiYy54bWx9"/>
            <L7p:VariableToSet stringValue="inputurl"/>
            <L7p:Base64Expression stringValue="JHtnYXRld2F5LnRlc3QueG1sfQ=="/>
            <L7p:VariableToSet stringValue="uri"/>
            <L7p:Base64ResponseBody stringValue="aGVsbG8="/>




Thanks in advance