new poll example SQL queries

diff --git a/templates/index.html.ep b/templates/index.html.ep
index 6a6bb96..afa76ee 100644 (file)
--- a/templates/index.html.ep
+++ b/templates/index.html.ep
@@ -18,7 +18,12 @@ Database schema:
 Gnuplot graphs:
 
 <ul>
 Gnuplot graphs:
 
 <ul>

-<li><a href="/gnuplot?sql=select start,ping_error,adsl_ok from poll">poll stats</a>
+<li>poll stats
+<ul>
+<li><a href="/gnuplot?sql=select start,queued,ping_ok,davolink_ok,easygateway_ok from cpe_poll order by start desc limit 200">CPE</a>
+<li><a href="/gnuplot?sql=select start,ok,queued,complete from dslam_poll where variant = 'ZTEDSLAM' order by start desc limit 200">ZTEDSLAM</a>
+<li><a href="/gnuplot?sql=select start,ok,queued,complete from dslam_poll where variant = 'ZTEMSAN' order by start desc limit 200">ZTEMSAN</a>
+</ul>

 <li><a href="/gnuplot?sql=select timestamp,snrtx,attntx,pwrtx,pwrrx,attnrx,snrrx from adsl where username='test36zg@h1snc'">adsl stat for single user</a>
 <li><a href="/gnuplot?sql=select timestamp,rtt from ping where ip << inet '10.17/16' order by timestamp desc limit 1000">ttl from 10.17 network</a>
 </ul>
 <li><a href="/gnuplot?sql=select timestamp,snrtx,attntx,pwrtx,pwrrx,attnrx,snrrx from adsl where username='test36zg@h1snc'">adsl stat for single user</a>
 <li><a href="/gnuplot?sql=select timestamp,rtt from ping where ip << inet '10.17/16' order by timestamp desc limit 1000">ttl from 10.17 network</a>
 </ul>