Splunk Search

regex help!

kiran331
Builder

How to extract the IP OR hostname from the field "source"?

source=/opt/var/log/splunk/ciscoasa/11.12.22.345/2017_06_05_21_cisco.log
source=/opt/var/log/splunk/ciscoasa/abc_xyz/2017_06_05_21_cisco.log

I need to extract 11.12.22.345 & abc_xyz

Tags (2)
0 Karma
1 Solution

inventsekar
SplunkTrust
SplunkTrust

Hi Kiran, Verified and this works fine -

source="ciscoasa.txt" | rex field=_raw "ciscoasa\/(?<ipAddress>.*)\/" | table ipAddress _raw

alt text

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !

View solution in original post

0 Karma

horsefez
Motivator

Hi,

because I was bored I made this redundant answer.

yoursearch | rex field=source "(?<host>[^\/]+)\/[^\/]+(?:$)"

gcusello
SplunkTrust
SplunkTrust

Hi kiran331,
Try this:

your_search | rex field=source "ciscoasa\/(?<host>[^\/]*)" | ...

you can test it at https://regex101.com/r/wrL9Ze/1

Bye.
giuseppe

0 Karma

inventsekar
SplunkTrust
SplunkTrust

Hi Kiran, Verified and this works fine -

source="ciscoasa.txt" | rex field=_raw "ciscoasa\/(?<ipAddress>.*)\/" | table ipAddress _raw

alt text

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma
Get Updates on the Splunk Community!

Splunk MCP & Agentic AI: Machine Data Without Limits

  Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...