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 → Organization → the organization set in the InfluxDB
• 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 activ, 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 Deteils 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 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.

InfluxDB & Grafana setup example with docker-compose

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:

1. create the docker-compose.yml
2. create a empty grafana.ini file
3. run docker-compose up -d
4. Login to the influxDB (Load Data -> API Token).
5. Create at read API token for grafana and a write API token for the Allegro Network Multimeter.
6. Login 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 querys in the Date Explorer of the InfluxDB)