How to export full device and interface reports from The Dude (v7.18.1)

[SNF]

Hello everyone,

I am using The Dude version 7.18.1 to monitor our MikroTik network. I would like to create a report (CSV or Excel) containing full information from all devices, including:

• Device IPs and names
• Interface information (status Up/Down, Rx/Tx, MTU, VLANs, etc.)
• SNMP data if available
• CPU, memory, and other relevant device statistics

Currently, I have not created any Probes yet, and I would like to know how to start from scratch, including:

1. Creating the necessary Probes to collect all interface and device data
2. Exporting this information automatically to a CSV or Excel file for all devices

Could you please advise the best approach to achieve this, or if there are any built-in reporting tools, scripts, or workflows in The Dude to generate comprehensive reports?

Thank you in advance for your help!

[patrikg]

@SNF

our MikroTik network

Is your network huge ?
Is this only one report job or would you use this for statistics for your network for the feature ?

I should not use dude to do this, there are more valuable apps to do this using databases and so on.

Something like this stack:

[GUIDE] Grafana, Prometheus, and snmp_exporter

This guide is for Ubuntu Server 22.04 and what I call Promstack (Grafana, Prometheus, and snmp_exporter). Have an installed, updated Ubuntu 18.04 or newer (preferably 22.04). Prep for Prometheus install: sudo apt update && sudo apt dist-upgrade -y sudo groupadd --system prometheus sudo useradd -s /sbin/nologin --system -g prometheus prometheus sudo mkdir /var/lib/prometheus for i in rules rules.d files_sd; do sudo mkdir -p /etc/prometheus/${i}; done sudo apt update sudo apt -y install wget cu…

You can see this picture what you get, and don't need a Native X86_64 App, this is from a webbrowser.

[Amm0]

The auto-discovery on a subnet will add the devices and create some initial probes – depending on what detected. Autodiscovery will work on a single IP too. But what probes it detects depends on stuff like username/password, SNMP profile has correct info, etc configured in server default).

Now in terms of generating a report...you are more limited. Basically you just can export CSV or SVG (for probe graphs) - but there is no master report so you have to combine CSV and SVG manually if one report with everything. On top, there is no API/CLI automation to generate the CSVs outside the Dude GUI, which means it's a multi-step manual process.

For monitoring and alerting of RouterOS devices, Dude works pretty well. For "reporting", you can basically extract the collected data.

[SNF]

Thank you for your answer!
We will have around 1,500 routers, so I would say our network is quite large. For the time being, I only need this report to monitor the routers. In the future, however, we are planning to use a dedicated tool for this purpose.

[SNF]

Thanks