Building for the Splunk Platform

How do I group the count of src_ip by month?

bayman
Path Finder

How do I group the count of src_ip by month?

This is what I have and shows the count of src_ip

index="cisco_asa" (sourcetype="cisco:asa" OR sourcetype="cisco:pix" OR sourcetype="cisco:fwsm")  src_ip="*" dest_port="*" dest_ip="*" | fields src_ip | where cidrmatch("192.168.1.0/24",src_ip) | stats count by src_ip
0 Karma
1 Solution

cmerriman
Super Champion
index="cisco_asa" (sourcetype="cisco:asa" OR sourcetype="cisco:pix" OR sourcetype="cisco:fwsm")  src_ip="*" dest_port="*" dest_ip="*" | fields src_ip date_month| where cidrmatch("192.168.1.0/24",src_ip) | stats count by src_ip date_month

will that work?

View solution in original post

0 Karma

ddrillic
Ultra Champion

Maybe something in the spirit of | timechart span=30d count by src_ip...

0 Karma

cmerriman
Super Champion
index="cisco_asa" (sourcetype="cisco:asa" OR sourcetype="cisco:pix" OR sourcetype="cisco:fwsm")  src_ip="*" dest_port="*" dest_ip="*" | fields src_ip date_month| where cidrmatch("192.168.1.0/24",src_ip) | stats count by src_ip date_month

will that work?

0 Karma

bayman
Path Finder

Close, this shows the month for each src_ip

Was hoping it'll show something like
January
192.168.1.5 - 1233
192.168.1.10 - 824

February
192.168.1.12 - 300
192.168.1.25 - 24

0 Karma

cmerriman
Super Champion
 index="cisco_asa" (sourcetype="cisco:asa" OR sourcetype="cisco:pix" OR sourcetype="cisco:fwsm")  src_ip="*" dest_port="*" dest_ip="*" | fields src_ip date_month| where cidrmatch("192.168.1.0/24",src_ip) | stats count by src_ip date_month|eval srcCount=src_ip+" - "+count|stats values(srcCount) as srcCount by date_month

what about adding this eval and stats to the end?

0 Karma

bayman
Path Finder

Works, thanks!

0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...