Splunk Search

How to extract 2 fields using rex?

LizAndy123
Path Finder

Hi, I am new to SPL and have figured out how to do one rex Field extract - like this

index=xxxxx  "PUT /app/1/projects" | rex field=_raw "HTTP\/1\.1\" (?P<Status_Code>[^\ ]*)"

this is from the following search results log line HTTP/1.1" 200 44 188

This gives me the Status code and I can sort them and report - example 200 , 201, 400 or 500

I need to use the last field (2 or 3) digits to get the speed - how would I do that - I am stuck with formatting

 

Thanks in advance

Labels (1)
Tags (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex "HTTP\/\d\.\d\"\s(?<Status_Code>\d+).*?(?<speed>\d+)$"

LizAndy123
Path Finder

Thanks this worked - I never came back on to say

0 Karma

yuanliu
SplunkTrust
SplunkTrust

this is from the following search results log line HTTP/1.1" 200 44 188

How about

| rex "HTTP/1.1\"\s+(?<Status_Code>\d+)\s+(?<field2>\d+)\s+(?<field3>\d+)"
Get Updates on the Splunk Community!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

April 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...