DX NetOps Manager

Expand all | Collapse all

DB QUERY TO GET VALUE

  • 1.  DB QUERY TO GET VALUE

    Posted 04-23-2019 06:48 AM

    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.



  • 2.  Re: DB QUERY TO GET VALUE

    Posted 04-24-2019 06:49 AM

    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