Hi Alberto, Please see in line.
> Date: Tue, 19 May 2015 17:44:10 +0200 > From: [email protected] > To: [email protected] > Subject: [Users] Querying API with timestamps > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; > format="flowed" > > Hi, > > I'm having troubles when using timestamps while querying the API using POST. > I got the timestamp of a previous message as reference (the eldest of > a previous query) for start_time and tried to do the following query > (The table we are querying is a working table from a custom sandesh > message): > { > "start_time": "1432045370076142", > "sort_fields": [], > "end_time": "now", > "table": "StatTable.CDNAgent.QoSInfo", > "select_fields": ["Source", "name", "T", "QoSInfo.cache_id", > "SUM(QoSInfo.service_quality)", "SUM(QoSInfo.hit_ratio)", > "COUNT(QoSInfo)"], > "where": [[{"value2": null, "suffix": null, "name": "name", "value": > "CDNDataAgent", "op": 1}]] > } > > Then the result we got was empty. Why is this happening? [Sundar] No matching entry/stat for name=“CDNDataAgent” [where clause] in the CDNAgent.QosInfo stat table for the specified start_time and end_time. Please verify if the value specified for name in the where clause is correct and/or the start_time/end_time is correct. > Also a related question, How are the timestamp of aggregations > calculated? Is it the min, max or average? [Sundar] “T” in “select_fields” indicates individual time sample => No aggregation > We are currently using OpenContrail 2.10. > Thanks, Sundar > > Best Regards, > Alberto. > > > > > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org > > > ------------------------------ > > End of Users Digest, Vol 21, Issue 9 > ************************************ _______________________________________________ Users mailing list [email protected] http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
