We are consuming metrics via Kafka. The metrics are being published as a string, with an extra % at the end. Looking for help on how to get this parsed/formatted so we can ingest as a metric into influxDB.
I tried using regex and a converter, but still nothing.
[[processors.regex]]
[[processors.regex.fields]]
key = “percentUtilisation”
pattern = “(.*)…"
replacement = "{1}”
[[processors.converter]]
[processors.converter.fields]
float = [“percentUtilisation”]
Here is the data being consumed from kafka in JSON format.
{“data”:{“Time”:“2020-04-07T23:12:44.070Z”,“target”:{“gateway”:“system-QA”,“agent”:“hostname1”,“managedEntity”:“hostname1”,“type”:“Infrastructure Defaults”,“maintype”:“CPU”,“dataview”:“CPU”,“filter”:{“osType”:“Linux”,“pluginName”:“CPU”}},“name”:“cpu_0”,“row”:{“type”:“GenuineIntel Intel®”,“state”:“on-line”,“clockSpeed”:“2000.00 Mhz”,“percentUtilisation”:“3.51 %”,“percentUserTime”:“2.40 %”,“percentKernelTime”:“1.10 %”,“percentWaitTime”:“0.00 %”,“percentIdle”:“96.49 %”,“percentIrq”:“0.00 %”,“percentSoftIrq”:“0.00 %”}},“operation”:“update”}
desired metrics to be used:
“percentUtilisation”:3.51
“percentUserTime”:2.40
“percentKernelTime”:1.10
“percentWaitTime”:0.00
“percentIdle”:96.49
“percentIrq”:0.00
“percentSoftIrq”:0.00
