Hey all,
Was wondering if there was a way to get the points the mikrotiks use for the Graphs. Just a list of points timestamped and their value. Or really any way to get to the data store powering the graphs, even if it’s a bit of a hack.
Doesn’t seem like that functionality is supported out of the box, but let me know if you have any ideas.
Thanks,
Using the API, you can use monitor-traffic (assuming traffic graphs are what interests you) to get data points at certain intervals (e.g. every second), and use a graph library for your language of choice to draw the graph using those data points… or don’t, and just store them for whatever reason.
Thanks boen, but sadly doesn’t really help. We do store some radio data to a database, but what I’m really looking for is to take advantage of data that’s already in the radio to maybe supplement gaps in our data. So I don’t care about generating new data, I want to get at what’s in there from before.
We enable all those graphs by default, so it will be great to pull that data and present it in a slightly more user-friendly manner
There’s got to be a data store on the box holding those points, does anyone from mikrotik know how we can get at it? Or are users deliberately excluded from access?
Thanks,
Issa
AFAIK, all “stats” data (whether it’s traffic or radio data) is not really stored on HDD anywhere, and is therefore not accessible in any fashion. You only need to use Winbox, and you’ll see it generates graphs from your current time onwards, as opposed to any previous times.
Of course, I could be wrong on that one…
I get what you’re saying about those live graphs generated from interface stats, I can understand the limitation there.
But if we’re able to define how often the data is written (/tool graphing store-every) http://wiki.mikrotik.com/wiki/Manual:Tools/Graphing
then we can assume the graphs are storing historical data somewhere local.
We should be able to get to it, right?