{"type":"api","title":"Get Stats Raw Data Troubleshooting Tools Diagnostics 2104","meta":{"id":"/apps/pubhub/media/cisco-catalyst-sd-wan-api-guide-20-18/1c4807bcb76af36988ebb37dc2e455b1787a155e/d2f02ba2-fd0d-3a26-bcc5-feafc8f24d17","info":{"title":"Monitoring and Troubleshooting","description":"Includes API operations for the following:\n- Real-time monitoring\n- Accessing statistics APIs and statistics bulk APIs\n- Retrieving device state\n- Managing alarms and events\n","contact":{"email":"vmanage@cisco.com"},"version":"20.18 - 2025-08-15"},"openapi":"3.1.0","servers":[{"url":"/dataservice"}]},"spec":{"tags":["Troubleshooting Tools - Diagnostics"],"description":"Get stats raw data","operationId":"getStatsRawData_TroubleshootingToolsDiagnostics_2104","parameters":[{"name":"page","in":"query","description":"page number","schema":{"type":"integer","format":"int64"}},{"name":"pageSize","in":"query","description":"page size","schema":{"type":"integer","format":"int64"}},{"name":"sortBy","in":"query","description":"sort by","schema":{"type":"string"}},{"name":"sortOrder","in":"query","description":"sort order","schema":{"type":"string"}}],"requestBody":{"description":"Stats query string","content":{"application/json":{"schema":{"type":"object"},"examples":{"Stats query string":{"description":"Stats query string","value":{"query":{"condition":"AND","rules":[{"value":["172.16.255.11"],"field":"source_local_ip","type":"string","operator":"in"},{"value":["completed"],"field":"status","type":"string","operator":"in"}]},"size":10000}}}}},"required":true},"responses":{"200":{"description":"Success","content":{"application/json":{"schema":{"type":"object"},"examples":{"Search result":{"description":"Search result","value":{"header":{"generatedOn":1719824542590,"viewKeys":{"uniqueKey":[],"preferenceKey":"grid-raw_speedtest"},"columns":[{"title":"Time","property":"entry_time","displayFormat":"DD MMM YYYY h:mm:ss A z","inputFormat":"unix-time","dataType":"date"},{"title":"Destination Device","property":"destination_local_ip","dataType":"string"},{"title":"Source Circuit","property":"source_circuit","dataType":"string"},{"title":"Destination Circuit","property":"destination_circuit","dataType":"string"},{"title":"Down Speed (Mbps)","property":"down_speed","dataType":"number"},{"title":"Up Speed (Mbps)","property":"up_speed","dataType":"number"},{"title":"Down Bandwidth (Mbps)","property":"down_bw","display":"formatKbpsToMbps","dataType":"number"},{"title":"Up Bandwidth (Mbps)","property":"up_bw","display":"formatKbpsToMbps","dataType":"number"}],"fields":[{"property":"entry_time","dataType":"date"},{"property":"destination_local_ip","dataType":"string"},{"property":"source_circuit","dataType":"string"},{"property":"destination_circuit","dataType":"string"},{"property":"down_speed","dataType":"number"},{"property":"up_speed","dataType":"number"},{"property":"down_bw","dataType":"number","display":"formatKbpsToMbps"},{"property":"up_bw","dataType":"number","display":"formatKbpsToMbps"},{"property":"session_id","dataType":"string"},{"property":"speedtest_id","dataType":"string"},{"property":"logid","dataType":"number"},{"property":"deviceUUID","dataType":"string"},{"property":"status","dataType":"string"}],"chart":{}},"pageInfo":{"startTime":"1719821609758","endTime":"1719821609758","count":1},"data":[{"entry_time":1719821609758,"up_speed":228,"down_speed":227.71,"up_bw":"NA","down_bw":"NA","destination_ip":"172.16.255.16","destination_local_ip":"172.16.255.16","source_ip":"172.16.255.11","source_local_ip":"172.16.255.11","source_circuit":"","destination_circuit":"--","session_id":"83a52af4-8daf-46e1-9f8c-34ab4225eff5","speedtest_id":"","logid":4,"device_uuid":"C8K-9abc344d-9193-41bb-bc1d-26c834c31d5e","status":"completed","error":"None","tenant":"default","port":"80","source_interface":"Tunnel0","destination_interface":"Tunnel0","source_interface_addr":"100.0.0.1","destination_interface_addr":"100.0.0.6"}]}}}}}},"400":{"description":"Bad Request"},"403":{"description":"Forbidden"},"500":{"description":"Internal Server Error"}},"x-roles-required":"default","method":"post","path":"/statistics/speedtest"}}