Splunk Search

Unable to extract IP Address and Port number with reg

RNB
Path Finder

I have an event that I want to extract the IP Address and Port number.

Mar 6 13:59:59 192.168.140.215 %ASA-4-106023: Deny udp src outside:xxx.xxx.xxx.xxx/xxxxx dst inside:xxx.xxx.xxx.xxx/xxxxx by access-group "outside_access_in" [0x0, 0x0]

The following search works and produces results.
(sourcetype=cisco_asa AND Deny NOT (search)) | rex field=Outside "outside:(?P[^/])(?P[^ ]*?)" | stats count by OutsideIP | sort -count

But this search works but does not produce any results.
(sourcetype=cisco_asa AND Deny NOT (search)) | rex field=Outside "outside:(?P[^/])(?P[^ ]*?)" | stats count by OutsidePort | sort -count

I have tried many variations to extract the OutsidePort with no success. What am I doing wrong?

Thank you
Randy

Tags (2)
0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

This works for me:

...  | rex "outside:(?<outside_ip>[^/]+)/(?<outside_port>\S+)" | stats count by outside_port

View solution in original post

s_linner
Engager

I think the only thing you forgot is the "/" between the extraction of "outsideip" and "outsideport", which martin_mueller has in his extraction...

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

This works for me:

...  | rex "outside:(?<outside_ip>[^/]+)/(?<outside_port>\S+)" | stats count by outside_port

RNB
Path Finder

I added the missing / between the round brackets to what I had but I still had problems. I kept fiddling with what I had unsuccessfully, but cutting & pasting exactly what you have does the job. Thank you.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...