Mysql Query To Obtain The Scope Of All OTK Clients

Products

• CA API Gateway

Issue/Introduction

Is there a mysql query we can execute in order to obtain the scope for all of our OTK clients?

Environment

CA API Gateway 10.x , 11.x

OTK 4.4 , 4.5, 4.6

Resolution

You can execute the following mysql query to obtain this information:

mysql

use otk_db;

select client_name, scope from oauth_client_key;