ntopng/contrib/Grafana-Dashboard-NTOPNG-Telegraf-SNMP-UNFI
darox 8fcf19571b
Create Grafana-Dashboard-NTOPNG-Telegraf-SNMP-UNFI
The following Grafana dashboard displays all available metrics for the NTOPNG data source plugin, plus data coming from the influxdb data source. 
Created on: Grafana v5.0.0 (commit: af6e283)
NTOPNG source: ntopng Community Edition v.3.2.180316 on pfsense 2.4.3-RELEASE (amd64) FreeBSD 11.1-RELEASE-p7
2018-04-13 21:59:59 +02:00

4954 lines
112 KiB
Text

{
"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": 4,
"links": [],
"panels": [
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "NTOPNG",
"format": "decbytes",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 3,
"x": 0,
"y": 0
},
"id": 39,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"$$hashKey": "object:1936",
"refId": "A",
"target": "host_192.168.1.154_interface_em0_traffic_total_bytes",
"type": "timeserie"
}
],
"thresholds": "",
"title": "WAN Interface - Volumen",
"transparent": true,
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "Telegraf Data",
"format": "bps",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 2,
"x": 3,
"y": 0
},
"id": 16,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"$$hashKey": "object:948",
"alias": "AP-UNFI-1 - Traffic in",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"unifiIfName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiIfTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiIfRxPackets"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiIfName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": "",
"title": "AP-UNFI-1 - Traffic in",
"transparent": true,
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "Telegraf Data",
"format": "bps",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 3,
"x": 5,
"y": 0
},
"id": 17,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "AP-UNFI-1 - Traffic out",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"unifiIfName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiIfTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiIfTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"*8"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiIfName",
"operator": "=",
"value": "eth0"
}
]
}
],
"thresholds": "",
"title": "AP-UNFI-1 - Traffic out",
"transparent": true,
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"aliasColors": {},
"cacheTimeout": null,
"combine": {
"label": "Others",
"threshold": 0
},
"datasource": "NTOPNG",
"fontSize": "80%",
"format": "short",
"gridPos": {
"h": 12,
"w": 8,
"x": 8,
"y": 0
},
"id": 37,
"interval": null,
"legend": {
"percentage": true,
"percentageDecimals": null,
"show": true,
"values": false
},
"legendType": "Right side",
"links": [],
"maxDataPoints": 3,
"nullPointMode": "connected",
"pieType": "donut",
"strokeWidth": "1",
"targets": [
{
"$$hashKey": "object:1787",
"hide": false,
"refId": "A",
"target": "host_192.168.1.154_interface_em0_allprotocols_bps",
"type": "timeserie"
},
{
"$$hashKey": "object:1788",
"hide": true,
"refId": "B",
"target": "host_192.168.1.1_interface_em0_allprotocols_bps",
"type": "timeserie"
}
],
"title": "WAN Interface - Verteilung per Applikation",
"transparent": true,
"type": "grafana-piechart-panel",
"valueName": "total"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "NTOPNG",
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 0
},
"id": 35,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1740",
"rawQuery": false,
"refId": "A",
"target": "host_192.168.1.154_interface_em0_allprotocols_bps",
"type": "timeserie"
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "WAN Interface - Verkehr per Applikation",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2009",
"format": "bps",
"label": "Durchsatz",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"$$hashKey": "object:2010",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"alert": {
"conditions": [
{
"evaluator": {
"params": [
50
],
"type": "lt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"A",
"1h",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
10
],
"type": "lt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"B",
"1h",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
}
],
"executionErrorState": "alerting",
"frequency": "60s",
"handler": 1,
"name": "Geschwindigkeit - Internet Alarm",
"noDataState": "keep_state",
"notifications": [
{
"id": 1
}
]
},
"aliasColors": {
"Download": "#e24d42",
"Upload": "#6ed0e0"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Home Assistant",
"fill": 1,
"gridPos": {
"h": 10,
"w": 8,
"x": 0,
"y": 2
},
"id": 4,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:2893",
"alias": "Download",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Mbit/s",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "entity_id",
"operator": "=",
"value": "speedtest_download"
}
]
},
{
"$$hashKey": "object:2894",
"alias": "Upload",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Mbit/s",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "entity_id",
"operator": "=",
"value": "speedtest_upload"
}
]
}
],
"thresholds": [
{
"colorMode": "critical",
"fill": true,
"line": true,
"op": "lt",
"value": 50
}
],
"timeFrom": null,
"timeShift": null,
"title": "Internet - Geschwindigkeit",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:3083",
"format": "Mbits",
"label": "Durchsatz",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"$$hashKey": "object:3084",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "NTOPNG",
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 6
},
"id": 40,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1740",
"rawQuery": false,
"refId": "A",
"target": "host_192.168.1.154_interface_em0_traffic_bps",
"type": "timeserie"
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "WAN Interface - Verkehr",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2009",
"format": "bps",
"label": "Durchsatz",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"$$hashKey": "object:2010",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Telegraf Data",
"editable": true,
"error": false,
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 0,
"y": 12
},
"id": 27,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "/:Out$/",
"transform": "negative-Y"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1072",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath0"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:1073",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath1"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:1074",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath2"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:1075",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath3"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:1076",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath4"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "AP-UNFI-1 - 5G Verkehr",
"tooltip": {
"msResolution": false,
"shared": true,
"sort": 0,
"value_type": "cumulative"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1111",
"format": "bps",
"label": "Durchsatz",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:1112",
"format": "pps",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Telegraf Data",
"editable": true,
"error": false,
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 8,
"y": 12
},
"id": 28,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "/:Out$/",
"transform": "negative-Y"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1159",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath0"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:1160",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath1"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:1161",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath2"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:1162",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath3"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:1163",
"alias": "$tag_unifiVapName:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapRxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"In"
],
"type": "alias"
}
],
[
{
"params": [
"unifiVapTxBytes"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "derivative"
},
{
"params": [
"*8"
],
"type": "math"
},
{
"params": [
"Out"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath4"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "AP-UNFI-1 - 2.4G Verkehr",
"tooltip": {
"msResolution": false,
"shared": true,
"sort": 0,
"value_type": "cumulative"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1198",
"format": "bps",
"label": "Durchsatz",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:1199",
"format": "pps",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"alert": {
"conditions": [
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"A",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"B",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"C",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"D",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"E",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"F",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"G",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"H",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
1000
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"I",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
}
],
"executionErrorState": "alerting",
"frequency": "60s",
"handler": 1,
"name": "Latenz - Internet alert",
"noDataState": "keep_state",
"notifications": []
},
"aliasColors": {
"Download": "#e24d42",
"Upload": "#6ed0e0"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "-- Mixed --",
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 12
},
"id": 5,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1243",
"alias": "20min.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "20min.ch"
}
]
},
{
"$$hashKey": "object:1244",
"alias": "amazon.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "amazon.com"
}
]
},
{
"$$hashKey": "object:1245",
"alias": "google.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "google.com"
}
]
},
{
"$$hashKey": "object:1246",
"alias": "instagram.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "instagram.com"
}
]
},
{
"$$hashKey": "object:1247",
"alias": "netflix.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "netflix.com"
}
]
},
{
"$$hashKey": "object:1248",
"alias": "reddit.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "reddit.com"
}
]
},
{
"$$hashKey": "object:1249",
"alias": "swisscom.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "swisscom.ch"
}
]
},
{
"$$hashKey": "object:1250",
"alias": "twitter.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "twitter.com"
}
]
},
{
"$$hashKey": "object:1251",
"alias": "youtube.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "youtube.com"
}
]
},
{
"$$hashKey": "object:1252",
"alias": "wikipedia.org",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "wikipedia.org"
}
]
},
{
"$$hashKey": "object:1253",
"alias": "github.com",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "github.com"
}
]
},
{
"$$hashKey": "object:1254",
"alias": "blick.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "blick.ch"
}
]
},
{
"$$hashKey": "object:1255",
"alias": "bluewin.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "bluewin.ch"
}
]
},
{
"$$hashKey": "object:1256",
"alias": "admin.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "N",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "admin.ch"
}
]
},
{
"$$hashKey": "object:1257",
"alias": "sbb.ch",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "O",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "sbb.ch"
}
]
},
{
"$$hashKey": "object:1258",
"alias": "Wingo Lausanne",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "P",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "speedtest-ls.wingo.ch"
}
]
},
{
"$$hashKey": "object:1259",
"alias": "Wingo Zürich",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "Q",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "speedtest.wingo.ch"
}
]
}
],
"thresholds": [
{
"colorMode": "critical",
"fill": true,
"line": true,
"op": "gt",
"value": 1000
}
],
"timeFrom": null,
"timeShift": null,
"title": "Internet - Latenz",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1391",
"format": "ms",
"label": "RTT",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:1392",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Telegraf Data",
"editable": true,
"error": false,
"fill": 1,
"gridPos": {
"h": 7,
"w": 8,
"x": 0,
"y": 18
},
"id": 30,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "/:Out$/",
"transform": "negative-Y"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "$tag_ifDescr:$col",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"ifDescr"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ifTable",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT non_negative_derivative(last(\"ifInDiscards\"), 1s) AS \"Drop:In\", non_negative_derivative(last(\"ifOutDiscards\"), 1s) AS \"Drop:Out\", non_negative_derivative(last(\"ifInErrors\"), 1s) AS \"Error:In\", non_negative_derivative(last(\"ifOutErrors\"), 1s) AS \"Error:Out\", non_negative_derivative(last(\"ifInUnknownProtos\"), 1s) AS \"Unkwn:In\" FROM \"ifTable\" WHERE \"agent_host\" =~ /^$host$/ AND \"ifOperStatus\" = 1 AND $timeFilter GROUP BY time($interval), \"ifDescr\" fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ifInDiscards"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"Drop:In"
],
"type": "alias"
}
],
[
{
"params": [
"ifOutDiscards"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"Drop:Out"
],
"type": "alias"
}
],
[
{
"params": [
"ifInErrors"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"Error:In"
],
"type": "alias"
}
],
[
{
"params": [
"ifOutErrors"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"Error:Out"
],
"type": "alias"
}
],
[
{
"params": [
"ifInUnknownProtos"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
"1s"
],
"type": "non_negative_derivative"
},
{
"params": [
"Unkwn:In"
],
"type": "alias"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "UNFI-AP-1 - Fehler",
"tooltip": {
"msResolution": false,
"shared": true,
"sort": 0,
"value_type": "cumulative"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "pps",
"label": null,
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Telegraf Data",
"editable": true,
"error": false,
"fill": 1,
"gridPos": {
"h": 7,
"w": 4,
"x": 8,
"y": 18
},
"id": 41,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:3451",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath0"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:3623",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath1"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:3695",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath2"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:3767",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath3"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
},
{
"$$hashKey": "object:3840",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath4"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "na"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "AP-UNFI-1 - 5G Qualität",
"tooltip": {
"msResolution": false,
"shared": true,
"sort": 0,
"value_type": "cumulative"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4097",
"format": "percent",
"label": null,
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:4098",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "Telegraf Data",
"editable": true,
"error": false,
"fill": 1,
"gridPos": {
"h": 7,
"w": 4,
"x": 12,
"y": 18
},
"id": 42,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:3451",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath0"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:3623",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath1"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:3695",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath2"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:3767",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath3"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
},
{
"$$hashKey": "object:3840",
"alias": "$tag_unifiVapName",
"dsType": "influxdb",
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"unifiVapName"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "unifiVapTable",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"unifiVapCcq"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 10"
],
"type": "math"
}
]
],
"tags": [
{
"key": "agent_host",
"operator": "=",
"value": "AP-UNIFI-1"
},
{
"condition": "AND",
"key": "unifiVapName",
"operator": "=",
"value": "ath4"
},
{
"condition": "AND",
"key": "unifiVapRadio",
"operator": "=",
"value": "ng"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "AP-UNFI-1 - 2.4G Qualität",
"tooltip": {
"msResolution": false,
"shared": true,
"sort": 0,
"value_type": "cumulative"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4097",
"format": "percent",
"label": null,
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:4098",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
]
},
{
"alert": {
"conditions": [
{
"evaluator": {
"params": [
100
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"A",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
100
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"B",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
100
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"C",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
100
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"D",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
},
{
"evaluator": {
"params": [
100
],
"type": "gt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"E",
"5m",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
}
],
"executionErrorState": "alerting",
"frequency": "60s",
"handler": 1,
"name": "Latenz - LAN alert",
"noDataState": "keep_state",
"notifications": []
},
"aliasColors": {
"Download": "#e24d42",
"Upload": "#6ed0e0"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "-- Mixed --",
"fill": 1,
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 18
},
"id": 6,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"$$hashKey": "object:1442",
"alias": "Internet Box",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "192.168.1.1"
}
]
},
{
"$$hashKey": "object:1443",
"alias": "ap-unifi-1",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "ap-unifi-1.local.lan"
}
]
},
{
"$$hashKey": "object:1444",
"alias": "srv-ubn-media-1",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "srv-ubn-media-1.local.lan"
}
]
},
{
"$$hashKey": "object:1445",
"alias": "srv-ubtuntu16-1",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "srv-ubuntu16-1.local.lan"
}
]
},
{
"$$hashKey": "object:1446",
"alias": "srv-ubtuntu16-1",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "srv-ubuntu16-1.local.lan"
}
]
},
{
"$$hashKey": "object:1447",
"alias": "srv-ubtuntu16-1",
"datasource": "Telegraf Data",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "ping",
"orderByTime": "ASC",
"policy": "default",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"average_response_ms"
],
"type": "field"
},
{
"params": [],
"type": "distinct"
}
]
],
"tags": [
{
"key": "host",
"operator": "=",
"value": "srv-ubn-services-1"
},
{
"condition": "AND",
"key": "url",
"operator": "=",
"value": "srv-ubuntu16-1.local.lan"
}
]
}
],
"thresholds": [
{
"colorMode": "critical",
"fill": true,
"line": true,
"op": "gt",
"value": 100
}
],
"timeFrom": null,
"timeShift": null,
"title": "LAN - Latenz",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1513",
"format": "ms",
"label": "RTT",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:1514",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
]
}
],
"refresh": "30s",
"schemaVersion": 16,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-24h",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
]
},
"timezone": "",
"title": "Network",
"uid": "er_N4Tkik",
"version": 139
}