Splunk Search

Field Extraction - same field from different log events

jbuhrmann
Engager

I have a firewall log search returning two different types of events but I'm trying to capture the source ip address from both. The events look like:
Deny inbound icmp src inside:172.22.15.90 ...
Inbound TCP connection denied from 172.22.15.90/53340 ...

The Field Extraction tool comes up with one or the other:
(?i) src inside:(?P[^/ ]+)
(?i) denied from (?P[^/ ]+)

Is there a way to combine the two regex statements into a single which will return a field called src_ip_inside for either event?

Tags (3)
0 Karma
1 Solution

Damien_Dallimor
Ultra Champion

Try something like :

... | rex field=_raw "(?i)(?:src inside:|denied from )(?<src_ip_inside>[^/ ]+)" | table src_ip_inside

View solution in original post

Damien_Dallimor
Ultra Champion

Try something like :

... | rex field=_raw "(?i)(?:src inside:|denied from )(?<src_ip_inside>[^/ ]+)" | table src_ip_inside

jbuhrmann
Engager

The field extraction worked great. Instead of | table at the end I used: | stats count(src_ip_inside) by src_ip_inside to get a table with each src ip and number of events for that ip. Thanks for the help!

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...