List all the policies used by specific assertions

Products

• CA API Gateway

Issue/Introduction

Command to list all the policies which is used by specific assertions.

Environment

Release: L7SMG299000-7.1-Mobile API Gateway-HARDWARE APPLIANCE DUAL CPU
Component:

Resolution

Please run the this query to list out all policies which is using specific assertion.

select hex(goid), name, version from policy where xml like '%:name%'\G;

Additional Information

Consider the right ASSERTION name in like phrase, from the above example as name.