Splunk Search

How to exclude private ip address range from results?

damode
Motivator

How to modify the below query to exclude private ip address range from source IPs (src_ip) ?

index=cisco eventtype=cisco-firewall host="*" action="blocked" src_ip="*" dest_ip="*" src_port="*" dest_port="*" transport="*" service="*" | top src_ip
0 Karma
1 Solution

harsmarvania57
SplunkTrust
SplunkTrust

Hi @damode,

You can use CIDR block to exclude private IP ranges.

For IPv4 you can try below query, if your organization is using some other IP ranges in private network then you need to add those in your search as well.

index=cisco eventtype=cisco-firewall host="*" action="blocked" dest_ip="*" src_port="*" dest_port="*" transport="*" service="*" NOT (src_ip="10.0.0.0/8" OR src_ip="172.16.0.0/12" OR src_ip="192.168.0.0/16") 

View solution in original post

msquicc
Explorer

Since Heff mentioned it, in order to validate private/public IPv4, I made myself an eval-based macro with the following:

case(
cidrmatch("10.0.0.0/8",$IP$),"False",
cidrmatch("172.16.0.0/12",$IP$),"False",
cidrmatch("192.168.0.0/16",$IP$),"False",
isnull($IP$) OR like($IP$,""), "False",
match($IP$,"^((25[0-5]|(2[0-4]|1\d|[1-9]|)\d)\.?\b){4}$"),"True")



Then, I can use it in any query like:

| eval Remote_Address_isExternal = `isExternalIPv4(Remote_Address)`

 

The last line tests for a valid IPv4 address.  The best regex for validating IPV4 is an ever-evolving conversation on stack overflow.  So, I used the latest from there, but from this highest rated answer, not the accepted one: https://stackoverflow.com/a/36760050/6376311

 

0 Karma

harsmarvania57
SplunkTrust
SplunkTrust

Hi @damode,

You can use CIDR block to exclude private IP ranges.

For IPv4 you can try below query, if your organization is using some other IP ranges in private network then you need to add those in your search as well.

index=cisco eventtype=cisco-firewall host="*" action="blocked" dest_ip="*" src_port="*" dest_port="*" transport="*" service="*" NOT (src_ip="10.0.0.0/8" OR src_ip="172.16.0.0/12" OR src_ip="192.168.0.0/16") 

damode
Motivator

Thanks alot!

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 ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...

SplunkTrust | 2024 SplunkTrust Application Period is Open!

It's that time again, folks! That's right, the application/nomination period for the 2024 SplunkTrust is ...