FETCH DATA GRAPHICS

RouterOS Scripting
1

Hi everybody, i’m new to this forum, new to mikrotik and my english is not as good as i would want, so bear with me.
I’ve been asked to create an automatic process to create reports of mikrotiks.
It’s a very simple report (to be send in pdf via email) with some of the performance graphics mikrotik routers create themselves.
First of all, i don’t know what the best approach to this would be.
Create a program that logs into the routers, download the graphics, create the PDF and send them…
Use fetch command to send the graphics to my computer and then work from that…
Also, all the mikrotiks are connected in the same network to a raspberry running ubuntu (that manages databases and so…). Maybe fetch the graphics to the raspberry and make the program there. The one that puts together the graphics with some very simple text into the PDF and email them…

Any suggestions? Thanks in advance!

2

All the graphics are accessible via the webinterface. You could just ‚steal‘ them from there. That should be possible with whatever coding-language you prefer.

3

Ps: the way i would do it: create a simple html - you can even include the images directly from the mikrotik webinterface. Install Ubuntu on your Raspberry and usw wkhtmltopdf to create a pdf from the html. A pdf script can be used to do that and send it as an email attachement.

4

I do use Splunk to graph MikroTik.
To get data fra Mikrotik to Splunk, I do use this way:

1: Syslog
2: SNMP
3: SSH (https://wiki.mikrotik.com/wiki/Use_SSH_to_execute_commands_(DSA_key_login)

See some example here:
http://forum.mikrotik.com/t/using-splunk-to-analyse-mikrotik-logs/105668/1

5

Wouldnt you give a third party access to your devices this way?

6

No, Splunk is run on my local server, ssh is run from same server with certificates, so a secure solution.