Skip to content

Instantly share code, notes, and snippets.

@jhenkens
Created October 6, 2020 00:54
Show Gist options
  • Save jhenkens/35fbdbfdd31fb04451652425eadabcdb to your computer and use it in GitHub Desktop.
Save jhenkens/35fbdbfdd31fb04451652425eadabcdb to your computer and use it in GitHub Desktop.
AT&T UVerse DSL Residental Gateway InfluxDB Telegraf Grafana Dashboard

I wrote a basic dashboard / telegraf plugin to poll the RG to get line stats.

[[inputs.exec]]
  name_override = "attrg"
  commands = ["/etc/telegraf/exec/attrg.py"]
  timeout = "5s"
  data_format = "json"
  json_strict = true
  interval="15s"
#!/usr/bin/env python3
from bs4 import BeautifulSoup
import json
import requests
import re
MODEM_URL = 'http://192.168.1.254/cgi-bin/broadbandstatistics.ha'
page = requests.get(MODEM_URL)
soup = BeautifulSoup(page.content, 'html.parser')
line_data = [
"LineState",
"DSSync",
"USSync",
"DSMax",
"USMax",
"Modulation",
"DataPath",
]
bi_dir_data = [
"SN",
"Attenuation",
"Power",
"Seconds",
"LOS",
"LOF",
"FEC",
"CRC",
]
global_data = [
"Transmit Packets",
"Transmit Errors",
"Transmit Discards",
"Transmit Bytes",
"Receive Packets",
"Receive Errors",
"Receive Discards",
"Receive Bytes",
"PTM Receive PDUs",
"Broadband Connection",
"Broadband Network Type",
"MTU",
]
time_data = [
"Severely Errored Seconds (SESL)",
"Unavailable Seconds (UASL)",
"DSL Initialization Timeouts",
]
time_keys = []
table_keys = []
for l in range(1, 3):
for d in line_data:
table_keys.append("Line" + str(l) + " " + d)
for d in ["DS", "US"]:
for k in bi_dir_data:
table_keys.append("Line" + str(l) + " " + k + " " + d + str(l))
for t in time_data:
time_keys.append(t + " Line " + str(l))
results = {}
for key in global_data:
key_results = soup.find("th", text=key).parent.find('td')
results[key] = key_results.text.strip()
for key in table_keys:
key_results = soup.find("td", {"headers": key})
results[key] = key_results.text.strip()
timed_table = soup.find('table', {"summary": "Table of timed statistics"})
for key in time_keys:
# line endings are weird for time_keys, do it inefficiently
key_results = [f for f in timed_table.findAll("td") if f.text and key in f.text][0]
key_result = key_results.parent.findAll('td')[-1]
dest_key = re.sub("\\([A-Z]+\\) ", "", key)
results[dest_key] = key_result.text.strip()
def float_value(v):
try:
return float(v)
except ValueError:
return v
def normalize(d):
# Replace spaces w/ underscores, lowercase dictionary keys and strip/convert values to integers
return {k.replace(" ", "_").lower(): float_value(v) for k, v in d.items()}
results = normalize(results)
results = {k: v for k, v in results.items() if isinstance(v, float)}
print(json.dumps(results, indent=2, sort_keys=True))
{
"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": 3,
"links": [],
"panels": [
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 32000,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "yellow",
"value": 16000
},
{
"color": "green",
"value": 24000
}
]
},
"unit": "Kbits"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 0,
"y": 0
},
"id": 14,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_dssync\") + mean(\"line2_dssync\") as \"Bonded Downstream\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Bonded Downstream",
"type": "gauge"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 3000,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "yellow",
"value": 1600
},
{
"color": "green",
"value": 2000
}
]
},
"unit": "Kbits"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 4,
"y": 0
},
"id": 15,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_ussync\") + mean(\"line2_ussync\") as \"Bonded Upstream\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Bonded Upstream",
"type": "gauge"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 8,
"y": 0
},
"id": 16,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (mean(\"line1_ussync\") / mean(\"line1_usmax\")) * 100 as \"Sync/Max US Line 1\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Sync/Max US Line 1",
"type": "gauge"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 12,
"y": 0
},
"id": 17,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (mean(\"line1_dssync\") / mean(\"line1_dsmax\")) * 100 as \"Sync/Max DS Line 1\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Sync/Max DS Line 1",
"type": "gauge"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 16,
"y": 0
},
"id": 18,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (mean(\"line2_ussync\") / mean(\"line2_usmax\")) * 100 as \"Sync/Max US Line 2\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Sync/Max US Line 2",
"type": "gauge"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 20,
"y": 0
},
"id": 19,
"options": {
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false
},
"pluginVersion": "7.2.0",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (mean(\"line2_dssync\") / mean(\"line2_dsmax\")) * 100 as \"Sync/Max DS Line 2\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Sync/Max DS Line 2",
"type": "gauge"
},
{
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 5
},
"id": 12,
"title": "Row title",
"type": "row"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "Kbits"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 6
},
"hiddenSeries": false,
"id": 2,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_ussync"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_dssync"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_ussync"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_dssync"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Sync rate",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "Kbits",
"label": null,
"logBase": 1,
"max": "25000",
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "Kbits"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 6
},
"hiddenSeries": false,
"id": 20,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_usmax"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_dsmax"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_usmax"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_dsmax"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Max sync rate",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "Kbits",
"label": null,
"logBase": 1,
"max": "25000",
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "dB"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 15
},
"hiddenSeries": false,
"id": 5,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_sn_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_sn_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_sn_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_sn_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "SNR Margin",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "dB",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "dB"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 15
},
"hiddenSeries": false,
"id": 10,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_attenuation_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_attenuation_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_attenuation_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_attenuation_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Attenuation",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "dB",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 24
},
"hiddenSeries": false,
"id": 8,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_crc_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_crc_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_crc_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_crc_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "CRC Errors - Total",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "none",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "dB"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 24
},
"hiddenSeries": false,
"id": 3,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_power_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_power_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_power_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_power_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Power",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "dB",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "s"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 33
},
"hiddenSeries": false,
"id": 4,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_seconds_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_seconds_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_seconds_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_seconds_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Errored Seconds",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "s",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 33
},
"hiddenSeries": false,
"id": 9,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_crc_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_crc_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_crc_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_crc_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Severely Errored Seconds",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "none",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 42
},
"hiddenSeries": false,
"id": 6,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_fec_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_fec_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_fec_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_fec_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "FEC Errors - Total",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "none",
"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
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fieldConfig": {
"defaults": {
"custom": {},
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 42
},
"hiddenSeries": false,
"id": 7,
"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": "$col",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "attrg",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"line1_attenuation_us1\") AS \"Line 1 US\", mean(\"line1_attenuation_ds1\") AS \"Line 1 DS\", mean(\"line2_attenuation_us2\") AS \"Line 2 US\", mean(\"line2_attenuation_ds2\") AS \"Line 2 DS\" FROM \"attrg\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"line1_fec_us1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "derivative"
},
{
"params": [
"Line 1 US"
],
"type": "alias"
}
],
[
{
"params": [
"line1_fec_ds1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "derivative"
},
{
"params": [
"Line 1 DS"
],
"type": "alias"
}
],
[
{
"params": [
"line2_fec_us2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "derivative"
},
{
"params": [
"Line 2 US"
],
"type": "alias"
}
],
[
{
"params": [
"line2_fec_ds2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"1m"
],
"type": "derivative"
},
{
"params": [
"Line 2 DS"
],
"type": "alias"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "FEC Errors - Per Minute",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "none",
"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
}
}
],
"schemaVersion": 26,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-15m",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "AT&T RG",
"uid": "6B_1tRcGk",
"version": 3
}
@jhenkens
Copy link
Author

jhenkens commented Oct 6, 2020

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment