Splunk Dev

Tricky regex

dbcase
Motivator

Hi,

I have this data

10.210.192.5 - - [26/Sep/2017:19:59:59 -0400] "POST /rest/icontrol/sites/266646/decreaseWatchCount HTTP/1.1" 200 - "-" "Mozilla/5.0 (Linux; Android 7.1.1; XT1635-01 Build/NDNS26.118-23-1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/61.0.3163.98 Mobile Safari/537.36" "-"  "-"


10.210.192.15 - - [26/Sep/2017:19:59:59 -0400] "GET /rest/icontrol/sites/236039/eventsByDay?startDate=2017-09-25&endDate=2017-09-25&maxResults=65536 HTTP/1.1" 200 68785 "https://portal.coxhomelife.com/sp/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36" "-"  "-"

10.210.192.5 - - [26/Sep/2017:19:59:59 -0400] "GET /rest/icontrol/sites/267452/fetchImage?imageId=5222117165&imageType=image HTTP/1.1" 200 187081 "-" "Mozilla/5.0 (iPhone; CPU iPhone OS 10_3_3 like Mac OS X) AppleWebKit/603.3.8 (KHTML, like Gecko) Mobile/14G60" "-"  "-"


10.210.192.15 - - [26/Sep/2017:19:59:59 -0400] "POST /rest/icontrol/sites/315568/network/instances/100876ffe9572a.0/functions/disarm HTTP/1.1" 202 9 "-" "Mozilla/5.0 (iPhone; CPU iPhone OS 10_3_3 like Mac OS X) AppleWebKit/603.3.8 (KHTML, like Gecko) Mobile/14G60" "-"  "-"

I need to be able to get the number (266646, 236039, 267452 already have regex for this) and the function. The function is the tricky one. Based on this data the functions would be:

decreaseWatchCount
eventsByDay
fetchImage
network

I've tried everything I can think of but I can't seem to find a way to be successful on all the different function formats.

Tags (2)
0 Karma
1 Solution

DalJeanis
Legend

If you post the regex that correctly gets the number, then this would be easier to be completely right. You are going to add this on the end of that regex, inside your quotes...

\/(?<function>[^?\d\/]+)

The above translates as, match one slash, and then take at least one character made up of anything that is not a question mark, whitespace, or a slash and put it into the variable called function.

I believe the whole thing will look like this...

| rex "\/rest\/icontrol\/sites\/(?<number>\d+)\/(?<function>[^?\d\/]+)"

View solution in original post

0 Karma

DalJeanis
Legend

If you post the regex that correctly gets the number, then this would be easier to be completely right. You are going to add this on the end of that regex, inside your quotes...

\/(?<function>[^?\d\/]+)

The above translates as, match one slash, and then take at least one character made up of anything that is not a question mark, whitespace, or a slash and put it into the variable called function.

I believe the whole thing will look like this...

| rex "\/rest\/icontrol\/sites\/(?<number>\d+)\/(?<function>[^?\d\/]+)"
0 Karma

dbcase
Motivator

Hi DalJeanis,

THANK YOU!!! That worked perfectly!

Get Updates on the Splunk Community!

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

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