Index: /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py
===================================================================
--- /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py	(revision 2461)
+++ /branches/amp_3_7/src/webui/webui/htdocs/new/src/hive/services/composer_query_service.py	(working copy)
@@ -352,3 +352,39 @@
     query_string = format_query_string(query_string)
     req_dict["body"] = 'q=' + query_string
     return req_dict
+
+
+def get_llb_stats(request):
+    req_dict = {
+        "url": "/v1/datasource/proxy/1/query",
+        "path": "db=composer&epoch=ms",
+        "method": "POST",
+        "body": {},
+        "config": {'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8'}
+    }
+    query_string = 'select LAST(linkGateway) AS linkGateway, last(linkThresh) as linkThresh, last(linkUsage) as linkUsage, last(linkBandwidIn) as linkBandwidIn, last(linkBandwidOut) as linkBandwidOut, last(linkConn) as linkConn, last(linkHits) as linkHits from llbStats where time > now()-20s group by agent_host, linkName, linkStatus;'
+    if 'query' in request:
+        if 'agent_host' in request['query']:
+            query_string = 'select LAST(linkGateway) AS linkGateway, last(linkThresh) as linkThresh, last(linkUsage) as linkUsage, last(linkBandwidIn) as linkBandwidIn, last(linkBandwidOut) as linkBandwidOut, last(linkConn) as linkConn, last(linkHits) as linkHits from llbStats where agent_host  =~ {} and time > now()-20s group by agent_host, linkName, linkStatus;'.format(
+                request['query']['agent_host'])
+    query_string = format_query_string(query_string)
+    req_dict["body"] = 'q=' + query_string
+    return req_dict
+
+
+def get_llb_stats_monitoring_data(request):
+    req_dict = {
+        "url": "/v1/datasource/proxy/1/query",
+        "path": "db=composer&epoch=ms",
+        "method": "POST",
+        "body": {},
+        "config": {'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8'}
+    }
+    query_string = 'select TOP(hits, 5), linkName, agent_host from (select max(linkHits)-min(linkHits) as hits FROM llbStats group by linkName, agent_host) where time > now()-20s;select TOP(last, 5), linkName, agent_host from (select last(linkConn) from llbStats group by linkName, agent_host) where time > now()-20s;'
+    if 'query' in request:
+        if 'agent_host' in request['query']:
+            query_string = 'select TOP(hits, 5), linkName, agent_host from (select max(linkHits)-min(linkHits) as hits FROM llbStats where agent_host  =~ {} group by linkName, agent_host) WHERE time > now()-20s;select TOP(last, 5), linkName, agent_host from (select last(linkConn) from llbStats where agent_host  =~ {} group by linkName, agent_host) where time > now()-20s;'.format(
+                request['query']['agent_host'])
+    query_string = format_query_string(query_string)
+    req_dict["body"] = 'q=' + query_string
+    return req_dict
\ No newline at end of file