Splunk Search

Check connection from same source to multiple destination

SIEMStudent
Path Finder

Hi guys,

I have a doubt regarding the mapping of connection from the same source IP to different destination IP.

In my query, I have to check if the same source reach more than 300 different destination IP.

Usually, If I had to report connection with source ip which appear more than 300 times, I know I can to write:

 

|stats count src_ip as source by source
|where count > 300 

 

But what about if I have to check the query requirements?

It shuold be something like:

|stats count src_ip as source, dest_ip as destination by source
|where destination > 300 

?

Labels (2)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @SIEMStudent,

You can try below;

| stats dc(dest_ip) as dest_count by src_ip
| where dest_count > 300 
If this reply helps you an upvote is appreciated.

View solution in original post

scelikok
SplunkTrust
SplunkTrust

Hi @SIEMStudent,

You can try below;

| stats dc(dest_ip) as dest_count by src_ip
| where dest_count > 300 
If this reply helps you an upvote is appreciated.

SIEMStudent
Path Finder

Thank you very much!

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Updates (ESCU) - New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 3 releases of new content via the Enterprise ...

Thought Leaders are Validating Your Hard Work and Training Rigor

As a Splunk enthusiast and member of the Splunk Community, you are one of thousands who recognize the value of ...

.conf23 Registration is Now Open!

Time to toss the .conf-etti 🎉 —  .conf23 registration is open!   Join us in Las Vegas July 17-20 for ...