DX NetOps

  • Private Community

  • 1.  How do we extract data timestamp using a OpenAPI query?

    Posted Jan 03, 2019 12:21 PM

    We're following some examples from OpenAPI QueryBuilder Examples - CA Performance Management - 3.6 - CA Technologies Documentation  and these are working fine. 

     

    Specifically we are using an amended version of the query in "Export As-Polled Bits-In and Bits-Out for Interfaces in a Group":

    http://da_host:8581/odata/api/interfaces?period=1w&resolution=RATE&$top=50&$skip=0&top=2016&$expand=portmfs&$select=Name,portmfs/im_BitsIn,portmfs/im_BitsOut&$filter=((groups/Name eq 'Boston'))

    This successfully returns the interface name and the bits in and out values for each poll.  But what select metric can we use to export the timestamp of each data point?

     

    We're unable to use the QueryBuilder at present due to some incompatibilities with our reverse proxy (I know using that would probably give me the answer in seconds!)

     

    Regards,

    Neville



  • 2.  Re: How do we extract data timestamp using a OpenAPI query?
    Best Answer

    Broadcom Employee
    Posted Jan 04, 2019 02:14 AM

    Hi Neville,

    it is as simple as adding "portmfs/Timestamp" to the select list, so it reads

    http://da_host:8581/odata/api/interfaces?period=1w&resolution=RATE&$top=50&$skip=0&top=2016&$expand=portmfs&$select=Name,portmfs/Timestamp,portmfs/im_BitsIn,portmfs/im_BitsOut&$filter=((groups/Name eq 'Boston'))

     

    Hth, Lutz.



  • 3.  Re: How do we extract data timestamp using a OpenAPI query?

    Posted Jan 04, 2019 03:33 AM

    Perfect, thanks Lutz.