09-15-2023 12:25 PM - edited 09-15-2023 12:35 PM
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
startDate | Yes | Starting time, in the format yyyy-mm-ddThh:mm:ss | Query | String |
endDate | Yes | Ending time, in the format yyyy-mm-ddThh:mm:ss | Query | String |
count | Optional | Number of records to query per page | Query | Number |
scrollId | Optional | Scroll 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 call | Query | String |
timeZone | Optional | Three-letter timezone | Query | String |
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
09-17-2023 10:03 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide