Splunk Search

how to exclucde number of values from search

Meharkant123
New Member

sourcetype="source_traffic" | stats values(dest_port) by dst_ip

Hi I am lookin for result of IP which have more than one port associate with it.
I would like to exclude the results one IP with one port.
e.g. current result

dest_ip dest_port
10.10.10.01 389
10.10.10.2 162
10.10.10.3 389
............ 143
............ 162
10.10.10.4 389
........... 162
........... 443.

I want result which shows only IP with more than 2 dest_port

dest_ip dest_port
10.10.10.3 389
............ 143
............ 162
10.10.10.4 389
........... 162
........... 443

0 Karma
1 Solution

somesoni2
Revered Legend

Do it like this

sourcetype="source_traffic" 
| stats values(dest_port) as Ports by dst_ip
| where mvcount(Ports)>1

View solution in original post

0 Karma

Meharkant123
New Member

Yes it is working ..much appreciated. thank you!!!

0 Karma

somesoni2
Revered Legend

Do it like this

sourcetype="source_traffic" 
| stats values(dest_port) as Ports by dst_ip
| where mvcount(Ports)>1
0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...