Skip to content

Instantly share code, notes, and snippets.

@bdwilson

bdwilson/edgerouter-grafana-dashboard.json

Created January 3, 2021 23:15
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bdwilson/cada386ee0619fdb8dd8dcb9f12f3e30 to your computer and use it in GitHub Desktop.
Save bdwilson/cada386ee0619fdb8dd8dcb9f12f3e30 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
edgerouter-grafana-dashboard.json
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"editable": true,
"gnetId": null,
"graphTooltip": 0,
"id": 11,
"iteration": 1609715656565,
"links": [
{
"icon": "external link",
"tags": [],
"title": "AT&T Data Usage",
"type": "link",
"url": "https://www.att.com/olam/passthroughAction.myworld"
}
],
"panels": [
{
"collapsed": false,
"datasource": "InfluxDB-Telegraf",
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 26,
"panels": [],
"title": "Real Time",
"type": "row"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 0,
"y": 1
},
"id": 23,
"interval": "1m",
"maxDataPoints": 999999,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1m) AS \"Download\" FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "1m",
"timeShift": null,
"title": "Wan Download",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 5,
"y": 1
},
"id": 24,
"maxDataPoints": 999999,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "1m",
"timeShift": null,
"title": "WAN Upload",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "orange",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbps"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 10,
"y": 1
},
"hideTimeOverride": true,
"id": 40,
"interval": "1m",
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "download-bits",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1m) AS \"Download\" FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "LineSpeed",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT mean(\"ifHighSpeed\") * 60000000 FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "table",
"select": [
[
{
"params": [
"ifHighSpeed"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"* 1000000"
],
"type": "math"
},
{
"params": [
"speed"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "1m",
"timeShift": null,
"title": "Wan Download",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "dl-bps",
"binary": {
"left": "download-bits",
"operator": "/",
"reducer": "sum",
"right": "60"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "percent-utilization",
"binary": {
"left": "dl-bps",
"operator": "/",
"reducer": "sum",
"right": "speed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "dl-mbps",
"binary": {
"left": "speed",
"operator": "*",
"reducer": "sum",
"right": "percent-utilization"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "purple",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbps"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 15,
"y": 1
},
"hideTimeOverride": true,
"id": 41,
"interval": "1m",
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "download-bits",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1m) AS \"Download\" FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "LineSpeed",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT mean(\"ifHighSpeed\") * 60000000 FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "table",
"select": [
[
{
"params": [
"ifHighSpeed"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"* 1000000"
],
"type": "math"
},
{
"params": [
"speed"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "1m",
"timeShift": null,
"title": "Wan Upload",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "dl-bps",
"binary": {
"left": "download-bits",
"operator": "/",
"reducer": "sum",
"right": "60"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "percent-utilization",
"binary": {
"left": "dl-bps",
"operator": "/",
"reducer": "sum",
"right": "speed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "dl-mbps",
"binary": {
"left": "speed",
"operator": "*",
"reducer": "sum",
"right": "percent-utilization"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "stat"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbps"
},
"overrides": []
},
"fill": 1,
"fillGradient": 2,
"gridPos": {
"h": 5,
"w": 20,
"x": 0,
"y": 6
},
"hiddenSeries": false,
"hideTimeOverride": true,
"id": 42,
"interval": "1m",
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.2.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "download-bits",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1m) AS \"Download\" FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "LineSpeed",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT mean(\"ifHighSpeed\") * 60000000 FROM \"1 Year\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "table",
"select": [
[
{
"params": [
"ifHighSpeed"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"* 1000000"
],
"type": "math"
},
{
"params": [
"speed"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": [],
"timeFrom": "60m",
"timeRegions": [],
"timeShift": null,
"title": "Wan Download",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "dl-bps",
"binary": {
"left": "download-bits",
"operator": "/",
"reducer": "sum",
"right": "60"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "percent-utilization",
"binary": {
"left": "dl-bps",
"operator": "/",
"reducer": "sum",
"right": "speed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "dl-mbps",
"binary": {
"left": "speed",
"operator": "*",
"reducer": "sum",
"right": "percent-utilization"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "decbps",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"collapsed": false,
"datasource": "InfluxDB-Telegraf",
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 11
},
"id": 18,
"panels": [],
"title": "WAN Utilization",
"type": "row"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 0,
"y": 12
},
"id": 9,
"interval": "1m",
"maxDataPoints": 999999999,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Wan Download Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 5,
"y": 12
},
"id": 4,
"maxDataPoints": 999999,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "WAN Upload Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 50
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 10,
"y": 12
},
"id": 11,
"interval": "1m",
"maxDataPoints": 999999,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Utilization Percent$/",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth0') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCOutOctets\"), 1m)) *8 AS \"Upload\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Cap Used (period)",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "reduceRow",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
},
{
"id": "calculateField",
"options": {
"alias": "Total Cap",
"binary": {
"left": "1.2",
"operator": "*",
"reducer": "sum",
"right": "1099511627776"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization",
"binary": {
"left": "Total Bandwidth",
"operator": "/",
"reducer": "sum",
"right": "Total Cap"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization Percent",
"binary": {
"left": "Utilization",
"operator": "*",
"reducer": "sum",
"right": "100"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
}
],
"type": "gauge"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 15,
"y": 12
},
"id": 10,
"interval": "1m",
"maxDataPoints": 999999,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Total Bandwidth$/",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "WAN Total Utilization",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
}
],
"type": "stat"
},
{
"aliasColors": {
"eth2 Output": "blue",
"eth2 input": "green"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "decbytes"
},
"overrides": []
},
"fill": 7,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 20,
"x": 0,
"y": 17
},
"hiddenSeries": false,
"id": 2,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 2,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.2.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1s) *8 AS \"input\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"input"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCOutOctets\"), 1s) * 8 AS \"Output\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [
"Output"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "EdgeRouter POE Wan Traffic",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "decbytes",
"label": "bytes",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"collapsed": false,
"datasource": "InfluxDB-Telegraf",
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 23
},
"id": 28,
"panels": [],
"title": "Today",
"type": "row"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"decimals": 2,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 0,
"y": 24
},
"hideTimeOverride": false,
"id": 29,
"interval": "1m",
"maxDataPoints": 1,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "value"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/d",
"timeShift": null,
"title": "Wan Download Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 5,
"y": 24
},
"id": 14,
"interval": "1m",
"maxDataPoints": 2764800,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/d",
"timeShift": null,
"title": "WAN Upload Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 50
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 10,
"y": 24
},
"id": 31,
"interval": "1m",
"maxDataPoints": 999999,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Utilization Percent$/",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) *8 AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCOutOctets\"), 1m)) *8 AS \"Upload\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/d",
"timeShift": null,
"title": "Daily Cap Used",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "reduceRow",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
},
{
"id": "calculateField",
"options": {
"alias": "Total Cap",
"binary": {
"left": "1.2",
"operator": "*",
"reducer": "sum",
"right": "1099511627776"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Daily Cap",
"binary": {
"left": "Total Cap",
"operator": "/",
"reducer": "sum",
"right": "30.42"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization",
"binary": {
"left": "Total Bandwidth",
"operator": "/",
"reducer": "sum",
"right": "Daily Cap"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization Percent",
"binary": {
"left": "Utilization",
"operator": "*",
"reducer": "sum",
"right": "100"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
}
],
"type": "gauge"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {},
"decimals": 1,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": ""
},
{
"color": "#EAB839",
"value": 50
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 15,
"y": 24
},
"id": 33,
"interval": "1m",
"maxDataPoints": 2764800,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Total Bandwidth$/",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/d",
"timeShift": null,
"title": "WAN Total Utilization",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
}
],
"type": "stat"
},
{
"aliasColors": {
"eth2 Output": "blue",
"eth2 input": "green"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "decbytes"
},
"overrides": []
},
"fill": 7,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 20,
"x": 0,
"y": 29
},
"hiddenSeries": false,
"id": 34,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 2,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.2.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1s) *8 AS \"input\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"input"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCOutOctets\"), 1s) * 8 AS \"Output\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
" * 8"
],
"type": "math"
},
{
"params": [
"Output"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": [],
"timeFrom": "now/d",
"timeRegions": [],
"timeShift": null,
"title": "EdgeRouter POE Wan Traffic",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "decbytes",
"label": "bytes",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"collapsed": false,
"datasource": "InfluxDB-Telegraf",
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 37
},
"id": 8,
"panels": [],
"title": "WAN Utilization (MTD)",
"type": "row"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "green",
"mode": "fixed"
},
"custom": {
"align": null,
"filterable": false
},
"decimals": 2,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 0,
"y": 38
},
"hideTimeOverride": false,
"id": 13,
"interval": "1m",
"maxDataPoints": 1,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time(1m) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/M",
"timeShift": null,
"title": "Wan Download Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 5,
"y": 38
},
"id": 30,
"interval": "1m",
"maxDataPoints": 2764800,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/M",
"timeShift": null,
"title": "WAN Upload Total",
"transformations": [],
"type": "stat"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 50
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 10,
"y": 38
},
"id": 12,
"interval": "1m",
"maxDataPoints": 999999,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Utilization Percent$/",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCInOctets\"), 1m)) *8 AS \"Download\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT cumulative_sum(non_negative_derivative(mean(\"ifHCOutOctets\"), 1m)) *8 AS \"Upload\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/M",
"timeShift": null,
"title": "Cap Used",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "reduceRow",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
},
{
"id": "calculateField",
"options": {
"alias": "Total Cap",
"binary": {
"left": "1.2",
"operator": "*",
"reducer": "sum",
"right": "1099511627776"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization",
"binary": {
"left": "Total Bandwidth",
"operator": "/",
"reducer": "sum",
"right": "Total Cap"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "Utilization Percent",
"binary": {
"left": "Utilization",
"operator": "*",
"reducer": "sum",
"right": "100"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
}
],
"type": "gauge"
},
{
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"custom": {},
"decimals": 1,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": ""
},
{
"color": "#EAB839",
"value": 50
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 15,
"y": 38
},
"id": 16,
"interval": "1m",
"maxDataPoints": 2764800,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "/^Total Bandwidth$/",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "7.2.0",
"targets": [
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Download"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "Wan $col",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "non_negative_derivative"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"Upload"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"timeFrom": "now/M",
"timeShift": null,
"title": "WAN Total Utilization",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Total Bandwidth",
"binary": {
"left": "Wan Download",
"operator": "+",
"reducer": "sum",
"right": "Wan Upload"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": false
}
}
],
"type": "stat"
},
{
"aliasColors": {
"eth2 Output": "blue",
"eth2 input": "green"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "InfluxDB-Telegraf",
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "decbytes"
},
"overrides": []
},
"fill": 7,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 20,
"x": 0,
"y": 43
},
"hiddenSeries": false,
"id": 15,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 2,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.2.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCInOctets\"), 1s) *8 AS \"input\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCInOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"input"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
},
{
"alias": "$tag_ifName $col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"ifName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifXTable",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT non_negative_derivative(mean(\"ifHCOutOctets\"), 1s) * 8 AS \"Output\" FROM \"autogen\".\"ifXTable\" WHERE (\"ifName\" = 'eth2') AND $timeFilter GROUP BY time($__interval), \"ifName\" fill(null)",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifHCOutOctets"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
" * 8"
],
"type": "math"
},
{
"params": [
"Output"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "ifName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": [],
"timeFrom": "now/M",
"timeRegions": [],
"timeShift": null,
"title": "EdgeRouter POE Wan Traffic",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "decbytes",
"label": "bytes",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
}
],
"refresh": "1m",
"schemaVersion": 26,
"style": "dark",
"tags": [
"Unifi",
"Bandwidth"
],
"templating": {
"list": [
{
"current": {
"selected": false,
"text": "1.2",
"value": "1.2"
},
"error": null,
"hide": 0,
"label": "DataCap (TB/M)",
"name": "datacap",
"options": [
{
"selected": true,
"text": "1.2",
"value": "1.2"
}
],
"query": "1.2",
"skipUrlSync": false,
"type": "textbox"
}
]
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Unifi",
"uid": "fnmOaI0Gka",
"version": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment