Splunk Search

Getting Count of specific value in json formatted log

kahlerb
Explorer

I have a json splunk log, and I need to get the count of the number of times the "message" field is equal to "Total request time". This same template is used for most all the logs, so the "message" field can have several different values.

{
api: my-fancy-api
app: MyApp
category: RESP_TIME
message: Total request time
reference_id: MyID123123
session_id: 1442877284-39497
time: 09-21-2015 23:14:45.023 +0000
total_request_time: 0.557
units: seconds
}

EDIT:
Ultimately I will need to get the count of multiple values for "message" in the same search string. One count for "Total request time" and then another count for "Sub-request time" etc.

Tags (1)
0 Karma

somesoni2
Revered Legend

Assuming you've setup KV_MODE=json to correctly parse the fields from your json data, try something like this

your base search message="Total request time" | stats count
0 Karma

kahlerb
Explorer

Thank you for the quick answer... please see the clarification I added with the edit.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Hello Splunkers,   So you searched, “what is the name of the usb key inserted by bob smith?”  Not gonna lie… ...

Automating Threat Operations and Threat Hunting with Recorded Future

    Automating Threat Operations and Threat Hunting with Recorded Future June 29, 2026 | Register   Is your ...