How can i download or List the Policies in our Gateway

Products

• CA API Gateway

Issue/Introduction

We have above 150 policies, how can i download the list of the policies we have. Any command that can help. We are on AWS and use RDS in this case. 

Environment

Release : 10.0

Component : API GATEWAY

Resolution

There are a few ways to get info from the SSG DB 

Option 1. Restman API - need to Internal service “Gateway REST Management Service”

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-0/apis-and-toolkits/rest-management-api.html

URI that returns policy sorted by name (note: it include all parameters, save to a file and grep for Name 

https://<gateway_hostname>:9443/restman/1.0/policies?sort=name&order=desc

Option 2. The other method would be JDBC query (NOTE need to access your mysql 8.0 RDS instance then run the query) 

Simple mysql query to retrieve all names in the policy table 

mysql> select name from ssg.policy order by name

 

OPTION 3  The GMU seem the best approach, (Note the list will include ALL policies including fragments as you can see)

GMU is another one example:  Need to encode the password;  https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-0/gateway-migration/gmu-command-help/encodepassword-command.html

C:\GMU>GatewayMigrationUtility.bat list --host <gatyeway_hostname> --trustCertificate -u admin -x <password>  -t policy

 

OUTPUT:

Warning: TLS server certificate check has been disabled

Running.............

04da7421d6896423da603e25c888686a        Fault.Client.SOAP.403.Forbidden

04da7421d6896423da603e25c888687d        Fault.Client.SOAP.000.DropConnection.StopProcessing

04da7421d6896423da603e25c8886890        authentication.SSL.SOAP.Client

04da7421d6896423da603e25c88868a3        authentication.SSL

04da7421d6896423da603e25c88868b6        Fault.Client.SOAP.000.DropConnection

095bb413e268e62ad01b1c785f2c3b3c        OTK Fail Message to HTML