search

chriswiggins / mikrotik-traffic-grapher

NodeJS Script to automatically capture data usage on mikrotik interfaces
7 stars 1 forks source link

Add support for vnstat db [Feature] #1

Open chrisallen opened 9 years ago

chrisallen commented 9 years ago

VNSTAT allows you to view an xml version of its db via the following command

vnstat -i pppoe0 --xml

Below is the output form the above command.

<vnstat version="1.11" xmlversion="1">
 <interface id="pppoe0">
  <id>pppoe0</id>
  <nick>pppoe0</nick>
  <created><date><year>2014</year><month>11</month><day>24</day></date></created>
  <updated><date><year>2014</year><month>12</month><day>08</day></date><time><hour>13</hour><minute>56</minute></time></updated>
  <traffic>
   <total><rx>480397162</rx><tx>342160733</tx></total>
   <days>
    <day id="0"><date><year>2014</year><month>12</month><day>08</day></date><rx>1359261</rx><tx>28204311</tx></day>
    <day id="1"><date><year>2014</year><month>12</month><day>07</day></date><rx>8545777</rx><tx>71183097</tx></day>
    <day id="2"><date><year>2014</year><month>12</month><day>06</day></date><rx>12333918</rx><tx>62927603</tx></day>
    <day id="3"><date><year>2014</year><month>12</month><day>05</day></date><rx>41319556</rx><tx>56367907</tx></day>
    <day id="4"><date><year>2014</year><month>12</month><day>04</day></date><rx>69103808</rx><tx>18804808</tx></day>
    <day id="5"><date><year>2014</year><month>12</month><day>03</day></date><rx>33644505</rx><tx>17320964</tx></day>
    <day id="6"><date><year>2014</year><month>12</month><day>02</day></date><rx>24249540</rx><tx>10103136</tx></day>
    <day id="7"><date><year>2014</year><month>12</month><day>01</day></date><rx>7252268</rx><tx>15250527</tx></day>
    <day id="8"><date><year>2014</year><month>11</month><day>30</day></date><rx>31991868</rx><tx>11638247</tx></day>
    <day id="9"><date><year>2014</year><month>11</month><day>29</day></date><rx>79970732</rx><tx>14871704</tx></day>
    <day id="10"><date><year>2014</year><month>11</month><day>28</day></date><rx>33338139</rx><tx>7879725</tx></day>
    <day id="11"><date><year>2014</year><month>11</month><day>27</day></date><rx>48539747</rx><tx>11045667</tx></day>
    <day id="12"><date><year>2014</year><month>11</month><day>26</day></date><rx>54271848</rx><tx>6429411</tx></day>
    <day id="13"><date><year>2014</year><month>11</month><day>25</day></date><rx>28844644</rx><tx>5218637</tx></day>
    <day id="14"><date><year>2014</year><month>11</month><day>24</day></date><rx>5631551</rx><tx>4914989</tx></day>
   </days>
   <months>
    <month id="0"><date><year>2014</year><month>12</month></date><rx>197808633</rx><tx>280162353</tx></month>
    <month id="1"><date><year>2014</year><month>11</month></date><rx>282588529</rx><tx>61998380</tx></month>
   </months>
   <tops>
    <top id="0"><date><year>2014</year><month>12</month><day>05</day></date><time><hour>00</hour><minute>00</minute></time><rx>41319556</rx><tx>56367907</tx></top>
    <top id="1"><date><year>2014</year><month>11</month><day>29</day></date><time><hour>00</hour><minute>00</minute></time><rx>79970732</rx><tx>14871704</tx></top>
    <top id="2"><date><year>2014</year><month>12</month><day>04</day></date><time><hour>00</hour><minute>00</minute></time><rx>69103808</rx><tx>18804808</tx></top>
    <top id="3"><date><year>2014</year><month>12</month><day>07</day></date><time><hour>00</hour><minute>00</minute></time><rx>8545777</rx><tx>71183097</tx></top>
    <top id="4"><date><year>2014</year><month>12</month><day>06</day></date><time><hour>00</hour><minute>00</minute></time><rx>12333918</rx><tx>62927603</tx></top>
    <top id="5"><date><year>2014</year><month>11</month><day>26</day></date><time><hour>00</hour><minute>00</minute></time><rx>54271848</rx><tx>6429411</tx></top>
    <top id="6"><date><year>2014</year><month>11</month><day>27</day></date><time><hour>00</hour><minute>00</minute></time><rx>48539747</rx><tx>11045667</tx></top>
    <top id="7"><date><year>2014</year><month>12</month><day>03</day></date><time><hour>00</hour><minute>00</minute></time><rx>33644505</rx><tx>17320964</tx></top>
    <top id="8"><date><year>2014</year><month>11</month><day>30</day></date><time><hour>00</hour><minute>00</minute></time><rx>31991868</rx><tx>11638247</tx></top>
    <top id="9"><date><year>2014</year><month>11</month><day>28</day></date><time><hour>00</hour><minute>00</minute></time><rx>33338139</rx><tx>7879725</tx></top>
   </tops>
   <hours>
    <hour id="0"><date><year>2014</year><month>12</month><day>08</day></date><rx>242782</rx><tx>2991998</tx></hour>
    <hour id="1"><date><year>2014</year><month>12</month><day>08</day></date><rx>53952</rx><tx>1891681</tx></hour>
    <hour id="2"><date><year>2014</year><month>12</month><day>08</day></date><rx>58793</rx><tx>2326083</tx></hour>
    <hour id="3"><date><year>2014</year><month>12</month><day>08</day></date><rx>63569</rx><tx>2578149</tx></hour>
    <hour id="4"><date><year>2014</year><month>12</month><day>08</day></date><rx>22116</rx><tx>345888</tx></hour>
    <hour id="5"><date><year>2014</year><month>12</month><day>08</day></date><rx>32856</rx><tx>1045061</tx></hour>
    <hour id="6"><date><year>2014</year><month>12</month><day>08</day></date><rx>63511</rx><tx>2199547</tx></hour>
    <hour id="7"><date><year>2014</year><month>12</month><day>08</day></date><rx>60282</rx><tx>2301254</tx></hour>
    <hour id="8"><date><year>2014</year><month>12</month><day>08</day></date><rx>82335</rx><tx>2760672</tx></hour>
    <hour id="9"><date><year>2014</year><month>12</month><day>08</day></date><rx>145515</rx><tx>3088942</tx></hour>
    <hour id="10"><date><year>2014</year><month>12</month><day>08</day></date><rx>204291</rx><tx>2712774</tx></hour>
    <hour id="11"><date><year>2014</year><month>12</month><day>08</day></date><rx>69711</rx><tx>1664414</tx></hour>
    <hour id="12"><date><year>2014</year><month>12</month><day>08</day></date><rx>61743</rx><tx>1109556</tx></hour>
    <hour id="13"><date><year>2014</year><month>12</month><day>08</day></date><rx>197805</rx><tx>1188292</tx></hour>
    <hour id="14"><date><year>2014</year><month>12</month><day>07</day></date><rx>100953</rx><tx>3931299</tx></hour>
    <hour id="15"><date><year>2014</year><month>12</month><day>07</day></date><rx>188308</rx><tx>3263077</tx></hour>
    <hour id="16"><date><year>2014</year><month>12</month><day>07</day></date><rx>186697</rx><tx>2942639</tx></hour>
    <hour id="17"><date><year>2014</year><month>12</month><day>07</day></date><rx>87096</rx><tx>3453202</tx></hour>
    <hour id="18"><date><year>2014</year><month>12</month><day>07</day></date><rx>85762</rx><tx>2934432</tx></hour>
    <hour id="19"><date><year>2014</year><month>12</month><day>07</day></date><rx>140089</rx><tx>1597241</tx></hour>
    <hour id="20"><date><year>2014</year><month>12</month><day>07</day></date><rx>1463512</rx><tx>2362895</tx></hour>
    <hour id="21"><date><year>2014</year><month>12</month><day>07</day></date><rx>536356</rx><tx>3255553</tx></hour>
    <hour id="22"><date><year>2014</year><month>12</month><day>07</day></date><rx>115479</rx><tx>4278552</tx></hour>
    <hour id="23"><date><year>2014</year><month>12</month><day>07</day></date><rx>73334</rx><tx>2696927</tx></hour>
   </hours>
  </traffic>
 </interface>
</vnstat>

Please consider adding support for vnstat :)

chriswiggins commented 9 years ago

Should be easy enough :-)

Any chance you could submit a PR for that jQuery bug you found?