List all the policies used by specific assertions

Products

• CA API Gateway

Issue/Introduction

Is there a command to list all the policies that are using specific assertions?

Environment

All supported versions of the API Gateway

Resolution

Run the following query to list all policies that are using specific assertions: select hex(goid), name, version from policy where xml like '%:name%'\G;

Replace name with the specific assertion you are looking for.