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!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...