bb-Ricardo/fritzinfluxdb

Get more DSL diag stats

ckoeber83 opened this issue · 6 comments

Hi bb-Ricardo,

many thanks for this work to get data out of the FB into Grafana!
Very well 👍

I'm looking for that kind of DSL diagnostic data (all number values) to be visible in your script and InfuxDB:
I'm also interested in the attenuation over time
grafik

For error statistik
I guess the "crc_errors" , "errored_seconds" and "severely_errored_seconds" are already the "Sekunden mit
Fehlern (ES), Fehlern (SES)"?

But I'm looking for DTU stats too:
grafik

It could be the following values but I'm not sure

service:WANDSLInterfaceConfig
FECErrors
ATUCFECErrors
HECErrors
ATUCHECErrors
CRCErrors
ATUCCRCErrors

service:WANDSLLinkConfig
AAL5CRCErrors
ATMCRCErrors

But i have no idea how to integrate this into your py. 🤔
Can you help there?

Hi,

pretty sure this could be added. This document 'https://avm.de/fileadmin/user_upload/Global/Service/Schnittstellen/wandslifconfigSCPD.pdf' contains these values but doesn't add a "translation". You could add them here:

"name": "WANDSLInterfaceConfig",
"actions": [
"GetInfo",
"GetStatisticsTotal",
"X_AVM-DE_GetDSLInfo"
],
"link_type": FritzBoxLinkTypes.DSL,
"value_instances": {
"NewDownstreamMaxRate": "maxBitRate_downstream:int",
"NewUpstreamMaxRate": "maxBitRate_upstream:int",
"NewDownstreamCurrRate": "downstream_dsl_sync_max:int",
"NewUpstreamCurrRate": "upstream_dsl_sync_max:int",
"NewDownstreamNoiseMargin": "snr_downstream:int",
"NewUpstreamNoiseMargin": "snr_upstream:int",
"NewDownstreamAttenuation": "attenuation_downstream:int",
"NewUpstreamAttenuation": "attenuation_upstream:int",
"NewSeverelyErroredSecs": "severely_errored_seconds:int",
"NewErroredSecs": "errored_seconds:int",
"NewCRCErrors": "crc_errors:int",
"NewDownstreamPower": "power_downstream:int",
"NewUpstreamPower": "power_upstream:int"
}

And test and compare which values match the ones in the user interface.

@bb-Ricardo
will verify that soon and get back to you.

Thanks in advance!

Hi @bb-Ricardo,

Sorry for any inconvenience. Here is the output from my browser:


grafik
grafik

Payload

{
	"xhr": "1",
	"sid": "15018212484c54b6",
	"lang": "de",
	"page": "dslStat",
	"xhrId": "refresh",
	"useajax": "1",
	"no_sidrenew": ""
}

Response

{
	"pid": "dslStat",
	"hide": {
		"shareUsb": true,
		"liveTv": true,
		"dectRdio": true,
		"dectMoniEx": true,
		"rss": true,
		"ssoSet": true,
		"dectMail": true,
		"provServ": true,
		"rrd": true,
		"liveImg": true
	},
	"timeTillLogout": "1128",
	"time": [],
	"data": {
		"isConnected": true,
		"negotiatedValues": [
			{
				"unit": "kbit/s",
				"title": "DSLAM-Datenrate Max.",
				"val": [
					{
						"us": "46720",
						"ds": "113312"
					}
				]
			},
			{
				"unit": "kbit/s",
				"title": "DSLAM-Datenrate Min.",
				"val": [
					{
						"ds": "1152"
					}
				]
			},
			{
				"unit": "kbit/s",
				"title": "Leitungskapazität",
				"val": [
					{
						"us": "43358",
						"ds": "121962"
					}
				]
			},
			{
				"unit": "kbit/s",
				"title": "Aktuelle Datenrate",
				"val": [
					{
						"us": "43357",
						"ds": "111881"
					}
				]
			},
			{
				"unit": "kbit/s",
				"title": "Min Effektive Datenrate",
				"val": [
					{
						"us": "43334",
						"ds": "111852"
					}
				]
			},
			{
				"title": "Nahtlose Ratenadaption",
				"val": [
					{
						"us": "aus",
						"ds": "aus"
					}
				]
			},
			{
				"title": "Trägertausch (Bitswap)",
				"val": [
					{
						"us": "an",
						"ds": "an"
					}
				]
			},
			{
				"title": ""
			},
			{
				"unit": "ms",
				"title": "Latenz",
				"val": [
					{
						"us": "< 1",
						"ds": "< 1"
					}
				]
			},
			{
				"title": "Impulsstörungsschutz (INP)",
				"val": [
					{
						"us": "12.0",
						"ds": "13.0"
					}
				]
			},
			{
				"title": "G.INP",
				"val": [
					{
						"us": "an",
						"ds": "an"
					}
				]
			},
			{
				"title": ""
			},
			{
				"unit": "dB",
				"title": "Störabstandsmarge",
				"val": [
					{
						"us": "6",
						"ds": "9"
					}
				]
			},
			{
				"unit": "dB",
				"title": "Leitungsdämpfung",
				"val": [
					{
						"us": "16",
						"ds": "17"
					}
				]
			},
			{
				"unit": "m",
				"title": "ungefähre Leitungslänge",
				"val": [
					"340"
				]
			},
			{
				"title": ""
			},
			{
				"title": "Profil",
				"val": [
					"17a"
				]
			},
			{
				"title": "G.Vector",
				"val": [
					{
						"us": "full",
						"ds": "full"
					}
				]
			},
			{
				"title": ""
			},
			{
				"title": "Trägersatz",
				"val": [
					"B43"
				]
			}
		],
		"errorCounters": [
			{
				"title": "Sekunden mit"
			},
			{
				"title": "Fehlern (ES)",
				"val": [
					{
						"us": "0",
						"ds": "12"
					}
				]
			},
			{
				"title": "Fehlern (SES)",
				"val": [
					{
						"us": "0",
						"ds": "8"
					}
				]
			},
			{
				"title": ""
			},
			{
				"title": "Nicht behebbare Fehler (CRC)"
			},
			{
				"title": "pro Minute",
				"val": [
					{
						"us": "0",
						"ds": "0"
					}
				]
			},
			{
				"title": "letzte 15 Minuten",
				"val": [
					{
						"us": "0",
						"ds": "0"
					}
				]
			},
			{
				"title": ""
			},
			{
				"title": "korrigierte DTU"
			},
			{
				"title": "pro Minute",
				"val": [
					{
						"us": "0.3",
						"ds": "1.5"
					}
				]
			},
			{
				"title": "letzte 15 Minuten",
				"val": [
					{
						"us": "5",
						"ds": "14"
					}
				]
			},
			{
				"title": ""
			},
			{
				"title": "unkorrigierte DTU"
			},
			{
				"title": "pro Minute",
				"val": [
					{
						"us": "0",
						"ds": "2.5"
					}
				]
			},
			{
				"title": "letzte 15 Minuten",
				"val": [
					{
						"us": "0",
						"ds": "0"
					}
				]
			}
		],
		"dataType": "dsl"
	},
	"sid": "15018212484c54b6"
}

Nonneed to be sorry, this is exactly what I needed. Thank you. 🙏🏼

Sorry for not working on this. It is currently blocked by this issue #114. I need to find a good way forward with influxDB as I don't like to repeat everything once again.

Any ideas from your side?