Hi Splunk Experts,
I have some data coming into splunk which has the following format:
[{"columns":[{"text":"id","type":"string"},{"text":"event","type":"number"},{"text":"delays","type":"number"},{"text":"drops","type":"number"}],"rows":[["BM0077",35602782,3043.01,0],["BM1604",2920978,4959.1,2],["BM1612",2141607,5623.3,6],["BM2870",41825122,2545.34,7],["BM1834",74963092,2409.0,8],["BM0267",86497692,1804.55,44],["BM059",1630092,5684.5,0]],"type":"table"}]
I tried to extract each field so that each value corresponds to id,event,delays and drops as a table using the below command.
index=result | rex field=_raw max_match=0 "\[\"(?<id>[^\"]+)\",\s*(?<event>\d+),\s*(?<delays>\d+\.\d+),\s*(?<drops>\d+)" | table id
event delays drops
I get the result in table format , however it spits out as one whole table and not individual entries and I cannot manipulate the result. I have tried using mvexpand , however it can only do for one value, so have not been helpful as well.
Does anyone know how we can properly get the table in splunk .
... View more