topic Unique Port Count Per IP in Splunk Search

Unique Port Count Per IP

ThisIsTom — Tue, 11 Jun 2013 20:38:03 GMT

I'm trying to find the number of unique ports accessed by IP's, by count. i.e. IP 8.8.8.8 connected to 5 unique ports. As of right now I am able to see the unique ports connected to by the IP address with the below command.

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

Is there a way to count those unique ports and display only that number? I have also tried:

sourcetype="source_traffic" dst_ip="x.x.x.x" | stats count values(src_port) by dst_ip

This one appears to the show a higher count than displayed port numbers.

TIA for any help!

Re: Unique Port Count Per IP

theouhuios — Tue, 11 Jun 2013 20:46:48 GMT

I guess you can do something like this

stats dc(src_port) by dst_ip

Re: Unique Port Count Per IP

ThisIsTom — Mon, 28 Sep 2020 14:04:22 GMT

Appreciate the quick response! It was on the money.

sourcetype="source_traffic" | stats dc(src_port) by dst_ip

Re: Unique Port Count Per IP

lbogle — Mon, 28 Sep 2020 16:45:36 GMT

I'm actually looking for something similar however not to find the count of ports but a listing of the actual ports that IP is using. So like a top 10 src_ip and then the top 3 ports that each of the src_ip's is using. Does that make sense?