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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...