Getting Data In
Highlighted

Key Extract from data

Observer

I have following logs

2020-06-30 17:58:28,307; thread=[workflow-503]; LogLevel=INFO; class=a.b.c.getData; milestone_end; id=asddd_ddd_ddd0, key1=193514641285449, tid=60d06-26c3-4281-8600-79338c6, flow=MessageMatching, RecordsCount=0, appId=appid1; msg=PerfStat-Repository: solrQuery={“q”:”a_id:193514641285449 AND (status:TO_BE_REVIEWED AND transaction_source:(SOURCE_A) AND amount:\\-80.00) AND -(deleted:true) AND -(is_primary:false)","start":"0","route.partition":["193514641285449"],"timeAllowed":10000}; recordCount=0; elapsedTime=3;; ​

 

Here we have solrQuery of the form {"q":"key1:value1 AND key2:value2 AND (key3:value3)};

I want to extract only key in the format key1,key2,key3

Labels (2)
Tags (1)
0 Karma
Highlighted

Re: Key Extract from data

SplunkTrust
SplunkTrust
To clarify, you want to extract "a_id", "status", "transaction_source", "amount", "deleted", "is_primary", "start", "route.partition". and "timeAllowed" as fields, correct?
Is the solrQuery field already extracted?
Do you want the keys extracted at index time or search time?
---
If this reply helps you, an upvote would be appreciated.
0 Karma
Highlighted

Re: Key Extract from data

Observer

To clarify, you want to extract "a_id", "status", "transaction_source", "amount", "deleted", "is_primary", "start", "route.partition". and "timeAllowed" as fields, correct?: Yes

Is the solrQuery field already extracted? No

Do you want the keys extracted at index time or search time? Didn't get that

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.