Are you a member of the Splunk Community?
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Help using REGEX to get the File Path from a field...
- 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
I'm attempting to categorize my splunk usage by source - using the logfile path as a rough way to group by application. So in my search, I'm retrieving the source - and then attempting to use REGEX to just show the filepath portion of the value.
Example...
This is my search query...
index=_internal source=license_usage type=Usage | eval MB=round((b/1024)/1024,2) | stats sum(MB) AS usage(mb) by h,s | sort 0 -usage(mb) | rename s as sourceDir | rename h as host
This is a sample of the values being returned for s
/cgu/prd/data/applogs/technical/uapesb02N1.PrdCguIccWesbAppM2.ServiceActivityEvent.log
/pi/prd/data/scv/CRODS_R3/logs/crods_r3.log
/cgu/prd/http/PrdCgu2Http/logs/access_log.2012-03-30
I've tried to use REX to remove the filename and just show the filepath portion using this...
| rex field=s mode=sed "s/(^.*)\(?!\)//g" |
but so far nothing seems to be working. Please help 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Does this do the trick ?
... | rex field=s "(?<filepath>(/\w+)+)/" | table filepath
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Does this do the trick ?
... | rex field=s "(?<filepath>(/\w+)+)/" | table filepath
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That worked perfectly. Thanks!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
updated the original answer and verified that it works in Splunk.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks - that's closer... It is returning just the last path... so /pi/prd/data/scv/CRODS_R3/logs/crods_r3.log becomes /logs
Index This | Why did the turkey cross the road?
Enter the Agentic Era with Splunk AI Assistant for SPL 1.4
Feel the Splunk Love: Real Stories from Real Customers
