Layer 7 API Gateway: Locating policies that are using specific assertions

Products

• STARTER PACK-7
• CA Rapid App Security
• CA API Gateway
• CA API Developer Portal
• CA API Gateway Enterprise Service Manager (Layer 7)

Issue/Introduction

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

Resolution

 

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, log in to the 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

•  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 it

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 name from SSG.policy where xml like '%EvaluateJsonPathExpression%';

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