Splunk Search

Brute Force Query Help

alanzchan
Path Finder

I am trying to mimic the table below. I have the count of the source IP, but how do I get the count of the respective subnets? In the example, they have it in the cell of each subnet value. Here is what I have so far:

 

index=xxxx sourcetype=xxxx "xxxx" 
| eval ERROR_CODE=case((RC="200"), "Success", (RC="400"), "User Not Found",(RC="401") , "Bad Password",(RC="500"), "Internal Server Error") 
| rex field=_raw "TCIP='(?<subnet_24>\d+\.\d+\.\d+)\.\d+" 
| rex field=_raw "TCIP='(?<subnet_16>\d+\.\d+)\.\d+\.\d+" 
| eval subnet_24 = subnet_24 +".x" 
| eval subnet_16 = subnet_16 +".x.x" 
| stats count(TCIP) by subnet_24 subnet_16 TCIP

 

 

alanzchan_0-1596468056771.png

Any help is appreciated!

Labels (5)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

you should try eventstats instead of stats. 

r. Ismo

0 Karma
Get Updates on the Splunk Community!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Announcing the General Availability of Splunk Enterprise Security 8.1!

We are pleased to announce the general availability of Splunk Enterprise Security 8.1. Splunk becomes the only ...

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...