Need query/command to find the customized OTK policies

Products

• CA API Gateway

Issue/Introduction

Is there a query or command to find out if any of the OTK policies are customized?

Environment

API Gateway 10.1

Resolution

You can get the OTK policy names and versions by running this query against the ssg database:

select name, version from policy where name like '%OTK%';

Typically, the customizable policies start with a # sign. To see only these policies, run this query against the ssg database:

select name, version from policy where name like '%#OTK%';

If the version number is greater than 0 or 1, there has been some kind of modification to the policy. 
If the version number is equal to 3, an upgrade has occurred and the previous version of the policy is part of the Revision History.