monthly data per IP

RouterOS Beginner Basics
1

Hi All,
Does anyone know something simple to keep track of data per IP on a central page ?
For a small housing complex i am looking for a simple solution to allow the users to monitor their monthly data.
Each user has a static IP. Each IP has a queue to limit the speed.

Ideal would be a simple page on a server that keeps track of hourly, daily, weekly and monthly data.

Is there something already out there or would i need to start trying to get my head around the scripting again ?
Had something in the past that would run a script on the mikrotik, it fetched a file on the server and placed the data of the queues there
User would put in their “username” and it would display the data. I lost those scripts after a meltdown of a disk and never got around re-doing it.

Greetings
Steve
ps i do not use fasttrack

2

Take a look at graphing. You can limit access to a single IP address for each queue. The end user can see it as a simple web page.
Not very high tech, but might accomplish what you want.

3

K6ccc, i have graphing enabled for some interfaces but it does not give totals?
Max In: 3.46Mb; Average In: 1.14Mb; Current In: 311.58Kb;
Max Out: 33.96Mb; Average Out: 7.15Mb; Current Out: 5.23Mb;
Am i overlooking a way to add the totals to the graphing ?
(indeed it would be a nice way to do it)

Greets
Steve

4

Take a look at Splunk for MikroTik, see link in my signature.

There I do use the accounting functionality to get traffic and graph it under “MikroTik Accouning Traffic” dashboard.
Works for all Router OS 6.x

Just as a test I looked at my wife phone. She as downloaded 85GB and sent 5.4GB last 30 days.

5

Functions like “accounting” or “volumetric totals” (= adding up to get totals over a time-period) are not done by Mikrotik. You will always see throughput in the graphs (Kbytes/sec / MBytes/sec etc)
Mikrotik will not do the summing/accounting for you, or at least not that I have found out :wink:

There are dozens of scripts (Perls, Python etc) that can perform this action, but they all will be running on a separate machine. Perhaps there exist some “free” cloud-based graphing solution that can be used, but you probably have to pre-process/parse the data a bit before ingestion. You don’t have any onsite compute resources running ?

6

Onsite nothing, but the location does have its own website, thats why some mikrotik based scripts and a php “collector” page would be ideal.
Just trying not to reinvent the wheel if something is already out there.
There used to be a set of scripts that would run completely inside the mikrotik and email the users but can not find even those any more
(they seem to be removed from the mikrotik wiki)

Jotne, Splunk is great but a bit overdone for this purpose only.

7

Ah and remember that in ROS 7.x the “accounting” feature is completely GONE and cannot be exported anymore. (so I’m told)
So if (ever) RouterOS 7.x reaches maturity and you need to update your devices for some reason …

8

Ah and remember that in ROS 7.x the “accounting” feature is completely GONE and cannot be exported anymore. (so I’m told)
So if (ever) RouterOS 7.x reaches maturity and you need to update your devices for some reason …
[/quote]

I can confirm that current beta of ROS v7.x does not have accounting (for the moment), so I am looking into how to use netflow with splunk.
Sadly not a simple process.

9

:laughing: :smiley:

10

Correct on no totals. As I said, a simple solution that is simple to implement.

11

That would really be a shame, i use the accounting in combination with the old Attix software on windows
But perhaps something else will come in its place

12

In the end i took this (its enough to start with)
https://github.com/muhannad0/mikrotik-traffic-counter

Made the script on the mikrotik like this and set a schedule to run every 10 minutes:

{
:local queueList [/queue simple find]
:foreach Client in=$queueList do={
:local ClientBytes [/queue simple get $Client bytes]
:local ClientName [/queue simple get $Client name]
:local BeforeSlash [:find $ClientBytes "/" -1 ]
:local ClientTXbytes [:pick $ClientBytes 0 $BeforeSlash ]
:local AfterSlash [:find $ClientBytes "/" +1 ]
:local ClientRXbytes [:pick $ClientBytes ($AfterSlash + 1) 255 ]
/tool fetch keep-result=no url=("https://yourserverurl/collector.php?sn=$ClientName&rx=$ClientRXbytes&tx=$ClientTXbytes")}
}
/queue simple reset-counters-all

For sure there are better ways to do it, and my “script skills” are very rusty :wink:

Greets and thanks for thinking along