How can I locate the names of policies using a specific assertion?

Document ID:  TEC1971838
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA API Management Gateway

Releases

  • CA API Management Gateway:Release:8.0
  • CA API Management Gateway:Release:8.1.1
  • CA API Management Gateway:Release:8.1.0
  • CA API Management Gateway:Release:8.2.00
  • CA API Management Gateway:Release:8.3
  • CA API Management Gateway:Release:9.1.00
  • CA API Management Gateway:Release:9.0.00
  • CA API Management Gateway:Release:8.4.01
  • CA API Management Gateway:Release:8.4.00
  • CA API Management Gateway:Release:8.4
  • CA API Management Gateway:Release:8.3.02
  • CA API Management Gateway:Release:8.3.01
  • CA API Management Gateway:Release:8.3.00

Components

  • API GATEWAY:APIGTW
Question:

How can I locate what policies are using a specific assertion?

Answer:

Policies are stored as XML in the SSG database and can be searched with a simple query. In this example we will locate all policies utilizing the 'Evaluate JSON Path Expression' assertion.

 

1. First, login to policy manager to obtain the name of the assertion.

  • Either locate a policy where the assertion is already in use or create a blank policy and drag the assertion into the policy
  • Highlight the assertion and copy it using the context menu

right_click.png

  •  Open a text editor and paste the previously copied assertion. You will now see the source XML, locate the assertion name as highlighted below and take note of i

src.png

2. Connect to the Gateway Database host and execute the below query at the mysql prompt replacing SSG with the name of your Gateway Database and EvaluateJsonPathExpression with the assertion name obtained above.

  • select SSG.name from policy where xml like '%EvaluateJsonPathExpression%';

example.png

You are returned a list of policy names where the assertion is in use.

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >