I have data like
Data: {"code": "abc", "version": "2018.6", "name": "testdata", "group": "QA", "DB": "oracle"}
in the field Message.
How can I export the key and value pair in a table.
So, I would need code, version, name, group, Db in a table.
I tried using spath but it didn't work as the data is not exactly in json format.
How can I get the data in tabular format.
Hope this helps
index=foo sourcetype=xyz ... | extract pairdelim="{,}" kvdelim=":" | table code version name group DB
Hope this helps
index=foo sourcetype=xyz ... | extract pairdelim="{,}" kvdelim=":" | table code version name group DB
It helps, thanks!