Identify Policies using a Private Key

Products

• CA API Gateway

Issue/Introduction

What is the query to identify all policies that are configured to use a certain private key?

Environment

All supported versions of the API Gateway

Resolution

Run the following queries:

select name from policy where xml like '%KeyName%<NAME_OF_KEY>%';

select name from policy where xml like '%KeyAlias%<NAME_OF_KEY>%';