Splunk Search

How to extract values?


My Log Contains


I am in need of VALUE field which will display 983123456 as an output tried with this query

|rex VALUE="(?[^\d*])" |table VALUE

please help

Tags (1)
0 Karma

Esteemed Legend

Like this:

| makeresults 
| eval _raw= "\"SeqNo\":4433221,\"T_CODE\":\"ABC\",\"VALUE\":983123456,\"VALUE2\":\"0000000000\","

| rename COMMENT AS "Everything above generates sample event data; everything below is your solution."

| rex max_match=0 "(?<KEY_1>[^:\"]+)\"?:\"?(?<VAL_1>[^:\"]+)\"?,"
| eval _raw = mvzip(KEY_1, VAL_1, "=")
| kv

I named them this way for a reason; search for _KEY_1 on this page:

0 Karma



Check this

| makeresults 
| eval temp= "\"SeqNo\":4433221,\"T_CODE\":\"ABC\",\"VALUE\":983123456,\"VALUE2\":\"0000000000\", "
|rex field=temp "VALUE\"\:(?P<value>\d+)"
0 Karma
Get Updates on the Splunk Community!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

Observability Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestSplunk APM's New Tag Filter ExperienceSplunk APM has updated ...

Security Newsletter Updates | March 2023

 March 2023 | Check out the latest and greatestUnify Your Security Operations with Splunk Mission Control The ...