Splunk Search

How can I extract key value pair in a table?

Explorer

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.

0 Karma
1 Solution

Path Finder

Hope this helps

index=foo sourcetype=xyz ... | extract pairdelim="{,}" kvdelim=":" | table code version name group DB

View solution in original post

Path Finder

Hope this helps

index=foo sourcetype=xyz ... | extract pairdelim="{,}" kvdelim=":" | table code version name group DB

View solution in original post

Explorer

It helps, thanks!

0 Karma