How do I group the count of src_ip by month?

[bayman]

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

[ddrillic]

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

[cmerriman · Accepted solution]

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?

[bayman]

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

[cmerriman]

 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?

[bayman]

Works, thanks!