Splunk Search

regex to extract from _raw

khhenderson
Path Finder

I am unfamiliar with regex. I need to separate every field in the _raw data from this line.

06/06 12:46:17 metrics ListeningThreads=3 IdleThreads=21 WaitingThreads=0 BusyThreads=0 TotalThreads=24 DelayedRequests=0 DroppedRequests=0 HandledRequests=28 HandledTime=543 DelayedTime=0 TotalMemory=4019584 FreeMemory=3549100

I know it can be done in the transform.conf and prop.conf files. I would just use a search command.

Would it be best to break it up using spaces? The order of the data should always be the same.
My final result would be a real time table or graph to monitor, BusyThreads, HandledRequests and FreeMemory.

Help for a newbie.

Tags (3)
0 Karma
1 Solution

Starlette
Contributor

did you already indexed this data? cause Splunks default behaviour is that it will extract the key=values pairs (due the = seperator)

View solution in original post

0 Karma

Starlette
Contributor

did you already indexed this data? cause Splunks default behaviour is that it will extract the key=values pairs (due the = seperator)

0 Karma

khhenderson
Path Finder

I think I've figured it out. This is close to what I need: | search "BusyThreads*" "HandledRequest*"

0 Karma

johandk
Path Finder

Make sure you have field discovery turned on when searching?

0 Karma

Starlette
Contributor

right, but you dont have the fieldextractions like Idletreads=21 etc?

0 Karma

khhenderson
Path Finder

Yes it's indexed.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...