Splunk Search

Extracting field using rex for URL

JoshuaJohn
Contributor

I have this search:

index=nitro_prod_ecomm sourcetype = nitro_access_log earliest=-30m@m | rex field=_raw "\d\d\:\d\d\:\d\d\s+(?\d+\.\d+)" | search ResponseTime>1

That gives me results like this:

10.022.020.203  10.200.130.180:7001 -   2016-08-15  01:09:02    4.55    GET   /product/nitro?skuId=11023031 skuId=11023031  200 124221]"

10.402.300.103  10.200.111.116:7001 -   2016-08-15  01:09:00    6.033   POST /myaccount/json/acc_nitro_login_json.jsp   -   302 0]"

I want to get "product" & "myaccount" into a field called page, basically whatever that first word is after GET, and POST

Any solutions? I can get the entire URL but I am unsure as to how to get just that first part.

0 Karma
1 Solution

skoelpin
SplunkTrust
SplunkTrust

Try this

... | rex (?<page>(GET|POST)\s+\/(\w+))

View solution in original post

0 Karma

skoelpin
SplunkTrust
SplunkTrust

Try this

... | rex (?<page>(GET|POST)\s+\/(\w+))

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...