Splunk Search

How to exract regex to my field

splunkn
Communicator

I am having events like below,

E.g. 1 Nov 7 10:18:49 111.222.333.444 Success user=abc userid=123 account=xyz
E.g.2 Nov 7 10:18:49 Success user=sdf userid=234 account=asdf destip=111.222.333.444

In some events (E.g. 1 ) we are having Destintation IP after the timestamp
But in some events (E.g. 2) we are having DestinationIP in a separate field named destip

How to write a regex for this to extract a single field as DestIP?
Could anyone help me with this?

Tags (2)
0 Karma
1 Solution

gfuente
Motivator

Hello

Supposing that you only have one ip in each event you could extract it with this regex, no matter where it is located:

(?<destip>\d+\.\d+\.\d+\.\d+)

Regards

View solution in original post

0 Karma

gfuente
Motivator

Hello

Supposing that you only have one ip in each event you could extract it with this regex, no matter where it is located:

(?<destip>\d+\.\d+\.\d+\.\d+)

Regards

0 Karma

gfuente
Motivator

Ok, then use this one:

(\d\d\:\d\d\:\d\d\s|destip\=)(?<destip>\d+\.\d+\.\d+\.\d+)
0 Karma

splunkn
Communicator

Many thanks 🙂

0 Karma

splunkn
Communicator

Sad part is my events are having more than one IPs in event like sourceip,thirdpartyip 😞

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...