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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...