DB QUERY TO GET VALUE

[Akash Ur Rehman keyani]

Hello All,

 

As my customers required Aggregation of interfaces and apply thresholds on its utilization like compared with last poll or addup values of last hour and check the threshold condition to violate. I want to built a supporting service with PC.

 

The help i require is i need a query through which i extract the data from CAPC DB.

Example: i want to get the current utilization value of in Bits of  BNCC router ----> Interface GI2/1.

or is there any other way to get the values else DR is there possibilities to pick it from DA or DC.

[Joseph Radosta]

Hi Akash:

 

You might try using openapi for something like this:

 

Maybe something like

 

Where in this case id equals 11888 is the id of the interface

 

 

Here is documentation on openapi:

 

https://docops.ca.com/ca-performance-management/3-6/en/apis/openapi

 

HTH

Joe