cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
301
Views
0
Helpful
1
Replies

Can the approutestatsstatistics get requests use query?

astem
Level 1
Level 1

I'd like to get per tunnel vqoe, jitter, loss and latency data for some segment of devices in the bulk api but not have to get every device in large Catalyst environments all at once.

Can bulk api calls like the approutestatsstatistics get below use queries (or some other filters) other than startDate and endDate?

  • Application-aware Routing Status
    Display statistics about data traffic characteristics for all operational router data plane tunnels.

    GET https://{vmanage-ip-address}/dataservice/data/device/statistics/approutestatsstatistics?startDate=yyyy-mm-ddThh:mm:ss&endDate=yyyy-mm-ddThh:mm:ss

 

From the doc

I see these are allowed get requests:

Name Required Description Parameter Type Data Type

startDateYesStarting time, in the format yyyy-mm-ddThh:mm:ssQueryString
endDateYesEnding time, in the format yyyy-mm-ddThh:mm:ssQueryString
countOptionalNumber of records to query per pageQueryNumber
scrollIdOptionalScroll identifier of the current bulk session. It acts as a pointer to the next data entry. The scrollId expires 10 minutes after it is returned in a callQueryString
timeZoneOptionalThree-letter timezoneQueryString

Can the bulkapi endpoint approutestatsstatistics accept a request parameter like query or some other filter on fields other that the listed ones above? I only see start date, end date, count ,timezone and scrollId as request parameters. If I could specify what records I wanted returned limited to a field in data (for example: seeing only data records with dst_port:123456 returned) it would reduce my data call sizes and limit the need to parse more than a reasonable number of pages of data.

I see there are post query fields for other non bulkapi approute endpoints I have not seen queries having any effect on the approutestatsstatistics bulk api calls though when sent in a get request and posts do not seem to be listed on the doc for this endpoint.

Ultimately I want to avoid using the realtime api or per device calls but It seems sending any data in query in the get to approutestatsstatistics has no effect.

Regards

1 Reply 1

Take a look at https://github.com/CiscoDevNet/SD-WAN-Reporting-Tool - i dont think the tool is supported anymore/maintained but should give you all the details you are looking for. 

Hope this helps.

Please mark this as helpful or solution accepted to help others
Connect with me https://bigevilbeard.github.io

Review Cisco Networking for a $25 gift card