{"type":"api","title":"Get Aggregation Data By Query 11","meta":{"id":"/apps/pubhub/media/sd-wan-api-20-16/58fb893fa751949ea20a40274e9ab219a20e19fa/e77267b5-7b4b-3f93-807c-c6d1c6b41343","info":{"title":"Cisco Catalyst SD-WAN Manager API","description":"The vManage API exposes the functionality of operations maintaining devices and the overlay network","contact":{"email":"vmanage@cisco.com"},"license":{"name":"Commercial License","url":"https://www.cisco.com/c/en/us/solutions/enterprise-networks/sd-wan/index.html"},"version":"2.0.0"},"openapi":"3.0.1","servers":[{"url":"/dataservice"}]},"spec":{"tags":["Monitoring - Interface Statistics"],"description":"Get aggregated data based on input query and filters. The data can be filtered on time and other unique parameters based upon necessity and intended usage","operationId":"getAggregationDataByQuery_11","parameters":[{"name":"query","in":"query","required":true,"schema":{"type":"string"},"example":{"query":{"condition":"AND","rules":[{"value":["24000"],"field":"entry_time","type":"date","operator":"last_n_hours"},{"value":["172.16.255.16"],"field":"vdevice_name","type":"string","operator":"in"},{"value":["ge0/1","system","vmanage_system","eth0","loopback65528","ge0/0"],"field":"interface","type":"string","operator":"in"}]},"sort":[{"field":"entry_time","type":"date","order":"asc"}],"aggregation":{"field":[{"property":"interface","sequence":1}],"histogram":{"property":"entry_time","type":"minute","interval":30,"order":"asc"},"metrics":[{"property":"rx_kbps","type":"avg"},{"property":"tx_kbps","type":"avg"}]}}}],"responses":{"200":{"description":"Success","content":{"application/json":{"schema":{"type":"array","items":{"type":"object","properties":{"data":{"type":"array","items":{"type":"object","properties":{"count":{"type":"integer","format":"int32"},"entry_time":{"type":"string"},"interface":{"type":"string"},"rx_kbps":{"type":"number"},"tx_kbps":{"type":"number"},"vdevice_name":{"type":"string"}},"$$ref":"#/components/schemas/InterfaceAggResp"}},"pageInfo":{"type":"object","properties":{"count":{"type":"integer","description":"number of alarms to be fetched","format":"int64"},"endTime":{"type":"integer","description":"end time of alarms to be fetched","format":"int64"},"startTime":{"type":"integer","description":"start time of alarms to be fetched","format":"int64"}},"$$ref":"#/components/schemas/PageInfo"}},"description":"interface aggregation response with page info","$$ref":"#/components/schemas/InterfaceAggRespWithPageInfo"}},"examples":{"Aggregated Data":{"description":"Aggregated Data","value":[{"entry_time":1673766000000,"count":1,"interface":"eth0","tx_kbps":0,"rx_kbps":1},{"entry_time":1673766000000,"count":1,"interface":"ge0/0","tx_kbps":0,"rx_kbps":0},{"entry_time":1673766000000,"count":1,"interface":"ge0/1","tx_kbps":0,"rx_kbps":0},{"entry_time":1673766000000,"count":1,"interface":"loopback65528","tx_kbps":0,"rx_kbps":0},{"entry_time":1673767800000,"count":6,"interface":"eth0","tx_kbps":0,"rx_kbps":0},{"entry_time":1673767800000,"count":6,"interface":"ge0/0","tx_kbps":0,"rx_kbps":0},{"entry_time":1673767800000,"count":6,"interface":"ge0/1","tx_kbps":0,"rx_kbps":0},{"entry_time":1673767800000,"count":6,"interface":"loopback65528","tx_kbps":0,"rx_kbps":0},{"entry_time":1673769600000,"count":6,"interface":"eth0","tx_kbps":1.8333333333333333,"rx_kbps":0.8333333333333334},{"entry_time":1673769600000,"count":6,"interface":"ge0/0","tx_kbps":0.3333333333333333,"rx_kbps":2.8333333333333335},{"entry_time":1673769600000,"count":6,"interface":"ge0/1","tx_kbps":0,"rx_kbps":0},{"entry_time":1673769600000,"count":6,"interface":"loopback65528","tx_kbps":0,"rx_kbps":0},{"entry_time":1673769600000,"count":2,"interface":"system","tx_kbps":0,"rx_kbps":0},{"entry_time":1673771400000,"count":6,"interface":"eth0","tx_kbps":0,"rx_kbps":0},{"entry_time":1673771400000,"count":6,"interface":"ge0/0","tx_kbps":5,"rx_kbps":48.833333333333336},{"entry_time":1673771400000,"count":6,"interface":"ge0/1","tx_kbps":0,"rx_kbps":0}]}}}}},"400":{"description":"Bad Request"},"403":{"description":"Forbidden"},"500":{"description":"Internal Server Error"}},"__originalOperationId":"getAggregationDataByQuery_11","method":"get","path":"/statistics/interface/aggregation"}}