Splunk Search

How to write the regex to extract the IP address and port number from my log files?

bluesaint
New Member

I have got a field in my log files that is storing failed login IP address "Failed password for invalid user astro from 65.208.122.48 on port 18982". Can anyone suggest how can I extract the IP address and port from text seen in quotations?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

In search mode you could use rex:

... | rex field=foo "from (?<ipAddress>[^\s]+) on port (?<port>\d+)" | ...
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...