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
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?
Maybe something in the spirit of | timechart span=30d count by 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 date_month| where cidrmatch("192.168.1.0/24",src_ip) | stats count by src_ip date_month
will that work?
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
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?
Works, thanks!