Splunk Search

How to edit my search to create a new extracted field with rex?

JoshuaJohn
Contributor

I have this search

index=nitro_prod_ecomm earliest=-30m@m | rex field=_raw "\d\d\:\d\d\:\d\d\s+(?\d+\.\d+)" | where ResponseTime>1| rex field=_raw "(?(GET|POST)\s+\/(\w+))" |stats count by header_page

It gets me the first part of a URL from the raw rex field, which is what I want.
I want to get this information into my extracted fields section on the left, I want to be able to click "header_page" and it will show me what is being displayed by this search such as "GET /store" etc. (Like below)
alt text

When attempting to create an extracted field via the automatic builder, it cannot do it and needs a custom written one. I tried just using the rex from the search, but it didn't seem to work.

Any ideas?

0 Karma
1 Solution

sundareshr
Legend

Add this to your props.conf

[sourcetype_stanza]
EXTRACT-headepage = (?<header_page>(GET|POST)\s+\/(\w+))

http://docs.splunk.com/Documentation/Splunk/6.4.2/Knowledge/Createandmaintainsearch-timefieldextract...

View solution in original post

0 Karma

sundareshr
Legend

Add this to your props.conf

[sourcetype_stanza]
EXTRACT-headepage = (?<header_page>(GET|POST)\s+\/(\w+))

http://docs.splunk.com/Documentation/Splunk/6.4.2/Knowledge/Createandmaintainsearch-timefieldextract...

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Can you share some sample data?

---
If this reply helps you, Karma would be appreciated.
0 Karma

JoshuaJohn
Contributor

header_page ________________count
GET /price
_______________________ 3
GET /product_________________3956
POST /rest
__________________373
GET /search
________________355
GET /search_error _
____________1
GET /store
______________________382

Basically this ^

0 Karma
Get Updates on the Splunk Community!

.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 ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...