Assertion Throughput Quota

Products

• CA API Gateway

Issue/Introduction

In which configuration file or database table is the counter ID information stored?

Environment

Release : 10.0

Component : API GATEWAY

Resolution

The throughput data is maintained in the counters table in SSG DB, the column is countername

Example mysql call to get all by asc order - The example is two assertions one by ClientIP and the other by Cluster

SELECT from_unixtime(last_update/1000), countername  AS `Date` FROM ssg.counters ORDER BY from_unixtime(last_update/1000) ASC;

 

2022-01-01 16:02:02.142 PRESET(eeb3791fca0a74b9)10.230.151.13

2022-01-01 16:02:02.078 PRESET(eeb3791fca0a74b9)