Statistics Export via InfluxDB

The Influx Export allows to write statistics from the Allegro Network Multimeter to an InfluxDB. This can be found in the menu Settings → Remote access & export → Influx Export.

InfluxDB settings

• Enabled: Enables the export.
• URL: URL of the InfluxDB (for example http://influx.mycompany.com:8086).
• API Token: Authentication token to access the InfluxDB server.
• Organization: The organization set in the InfluxDB.
• Bucket: Name of the bucket in which the statistics should be stored.
• Check TLS Certificates: For HTTPS Connections. Disable if a self signed certificate is used for the InfluxDB server.

Export Settings

Option	InfluxDB measurement name	Description
Interval (seconds)	-	Specifies the interval (in seconds) in which the statistics data from the Allegro Network Multimeter are written to the InfluxDB. The value must be greater than or equal to 1.
Resolution (seconds)	-	Specifies the resolution (in seconds) of the statistics. For example, 1 = one measurement every second, 10 = one measurement every 10 seconds. The value must be greater than or equal to 1. The value may not greater than the interval.
System Load Statistics	system	Save the system load, memory load, packet ingress load and statistics-availability.
System Health	system	Save the TBW for each disk.
Ring Buffer Usage Statistics	system	Save the Ring Buffer Usage in bytes.
Global Counters	global-counters	Save the global counters MAC count, IP count, connection count, connection active, connection maximum, connection capacity.
Interface Statistics	interface-[interface number]	Save the Bytes and Packets (rx/tx) of all network interfaces.
Virtual Link Groups Statistics	virtualLinkGroup-[name]	Save the Bytes and Packets (rx) of all Virtual Link Groups.
IP Global Statistics	ip-global	Save the Bytes and Packets for each protocol.
IP Countries Statistics	ip-countries	Save the Bytes and Packets (rx/tx) of each country.
IP Address Statistics	ip-[address]	Save the Bytes and Packets (rx/tx) for a list of IP-Devices. Addresses (IPv4/IPv6) separated by comma, without spaces.
IP Address Details Statistics	ip-[address]	Save the Bytes and Packets for each protocol for a list of IP-Addresses. Addresses (IPv4/IPv6) separated by comma, without spaces.
IP Address Peers Statistics	ip-[address]-peers	Save the Bytes and Packets for all peers of a list of IP-Addresses. Addresses (IPv4/IPv6) separated by comma, without spaces.
DNS Statistics	dns	Save the global DNS request/replies statistic.
ARP Statistics	arp	Save the global ARP request/replies statistic.
TCP Syn Response Time Statistics	tcp-syn-response-time	Save the global TCP SYN response time.

Constraint

Only traffic measurement values from the default virtual link group will be collected.

InfluxDB & Grafana setup example with Docker-compose

1. Create the docker-compose.yml file with the content:

   version: "3.6"
   services:
     influxdb:
       image: influxdb:latest
       container_name: influxdb
       restart: always
       environment:
         - DOCKER_INFLUXDB_INIT_MODE=setup
         - DOCKER_INFLUXDB_INIT_USERNAME=admin
         - DOCKER_INFLUXDB_INIT_PASSWORD=a_secure_password
         - DOCKER_INFLUXDB_INIT_ORG=MyCompany
         - DOCKER_INFLUXDB_INIT_BUCKET=allegro-network-multimeter
       ports:
         - "8086:8086"
       volumes:
         - influxdb-data:/var/lib/influxdb2
         - influxdb-conf:/etc/influxdb2
   
     grafana:
       image: grafana/grafana-oss:latest
       container_name: grafana
       restart: always
       depends_on:
         - influxdb
       environment:
         - GF_SECURITY_ADMIN_USER=admin
         - GF_SECURITY_ADMIN_PASSWORD=a_secure_password
       links:
         - influxdb
       ports:
         - "3000:3000"
       volumes:
         - grafana-data:/var/lib/grafana
         - grafana-provisioning:/etc/grafana/provisioning
         - ./grafana.ini:/etc/grafana/grafana.ini
   
   volumes:
     influxdb-data:
     influxdb-conf:
     grafana-data:
     grafana-provisioning:

2. Create an empty grafana.ini file.

3. Run docker-compose up -d

4. Login to the influxDB (Load Data → API Token).

5. Create a read API token for Grafana and a write API token for the Allegro Network Multimeter.

6. Login to the Allegro Network Multimeter.

7. Setup the Influx Export (Settings → Remote access & export → Influx Export).

8. Login to Grafana.

9. Add a new data source from the type InfluxDB (Settings → Data sources):

   • Query Language: Flux
   • URL: http://influxdb:8086
   • Auth: none
   • InfluxDB Details:
     • Organization: Your Organization from the Docker-compose file.
     • Token: Your Grafana read token.
     • Default Bucket: Your Bucket from the Docker-compose file.
   • Save & Test.

10. Create a new Dashboard (Dashboard → new Dashboard).

11. Create a new Panel and add a flux query (you can generate simple queries in the Data Explorer of the InfluxDB).