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

Document ID : KB000015359
Last Modified Date : 18/07/2018
Show Technical Document Details

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


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


  •  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


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.