Splunk Search

Help on Splunk query

suvi6789
Path Finder

Hi, 
I have 4 fields in my index 
ID, Method, URL, HTTP_responsecode

ID is in the form of XXXX-YYYY-ZZZZ-AAAA, 
Now, I want to delimit the ID column and extract YYYY value then run a stats command with the delimited value by HTTP_responsecode

Something as below 

Delimited_IDHTTP_responsecodeCount
YYYY200

10

 

Please could you help on how to delimit the value in the above format mentioned and how to use the new delimited value in a stats command 

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

There are a couple of ways to get the desired field from the ID.

| rex field=ID "-(?<Delimited_ID>[^-]+)"
``` OR ```
| eval tmp = split(ID, "-")
| eval Delimited_ID = mvindex(tmp,1)

Use the new field in a stats command just as you would any other field.

| stats count as Count by Delimited_ID, HTTP_responsecode

 

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...