Hi all.
I've been having problems with indexing where in the JSON is returning values in string format but I would like to remove the quotes on all values
"dn": "topology/pod-1/node-104/sys/phys-[eth1/48]/CDeqptEgrTotal5min",
"pktsRateMax": "302.633041",
"pktsThr": "",
"bytesPer": "5011221",
"pktsBase": "0",
"lastCollOffset": "119",
"pktsRate": "173.151443",
"pktsRateTtl": "2072.598565",
"host": "172.17.0.1",
"utilTr": "0",
"bytesBase": "0",
"pktsMax": "2724",
"bytesRate": "41760.523004",
"pktsTrBase": "55599",
"pktsRateThr": "",
"pktsRateLast": "82.000000",
"bytesRateMax": "68796.454545",
"utilMax": "0",
"bytesRateTrBase": "43812.610741",
"childAction": "",
"repIntvStart": "2018-03-13T16:59:58.913+00:00",
"utilTtl": "0",
"bytesThr": "",
"pktsRateSpct": "0",
"utilSpct": "0",
"port": 44352,
"bytesRateMin": "18162.000000",
"bytesRateAvg": "41378.273727",
"utilThr": "",
"repIntvEnd": "2018-03-13T17:01:58.912+00:00",
"status": "",
"pktsSpct": "0",
"bytesMax": "756761",
"utilLast": "0",
"pktsCum": "967969755",
"bytesRateTr": "0.000000",
"interface": "104/1/48",
"bytesRateThr": "",
"pktsMin": "624",
"pktsAvg": "1731",
"bytesSpct": "0",
"utilAvg": "0",
"utilMin": "0",
"@version": "1",
"pktsLast": "738",
"bytesRateLast": "20235.222222",
"bytesMin": "163458",
"bytesAvg": "417601",
"class_name": "eqptEgrTotal5min",
"utilTrBase": "0",
"pktsRateTrBase": "187.235202",
"bytesRateTtl": "496539.284727",
"pktsTr": "0",
"bytesRateSpct": "0",
"bytesLast": "182117",
"bytesTr": "0",
"cnt": "12",
"bytesCum": "235163782693",
"pktsPer": "20778",
"pktsRateTr": "0.000000",
"@timestamp": "2018-03-13T17:02:03.444Z",
"pktsRateAvg": "172.716547",
"pktsRateMin": "69.333333",
"bytesTrBase": "13021484"
what is the best way please that is scalable.
I have seen the gsub option but I don't seem to find the right combination.
I have tried this from a previous post.
mutate { gsub => [ "", """, "" ]}
But the logstash fails.
Any advice how i can remove for example and make it as
"pktsRateAvg": 172.716547,
"pktsRateMin": 69.333333,
"bytesTrBase": 13021484
Thanks in advance for your help