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.
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: