Join the Conversation
- Find Answers
- :
- Apps & Add-ons
- :
- Splunk Development
- :
- Splunk Dev
- :
- Re: Tricky regex
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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\/]+)"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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\/]+)"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi DalJeanis,
THANK YOU!!! That worked perfectly!
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
From Data to Insight: Announcing the Winners of the Splunk Dashboard Contest
Splunk Developers: Construct Your Future at the .conf26 Builder Bar
Quick connection discovery mode for forwarders
