How to find all policies that include the “Fragment- Enable Portal Metrics”

Products

• CA API Gateway

Issue/Introduction

Need to find all policies that had the “Fragment- Enable Portal Metrics”

The updates to this fragment takes a long time to complete. Looking to understand where it’s implemented 

Environment

Release : 11.0

Resolution

The query will provided the police name that includes that fragment named Enable Portal Metrics 

# mysql use ssg

mysql> select name from ssg.policy where xml like "%EnablePortalMetrics%";

NOTE: Substitute EnablePortalMetrics with a different assertions name to retrieve all the service names