Splunk Search

How to chart elapsed time performance data from dbquery?

danoconnl
Explorer

I've got a db query that returns an activity name and then the elapsed time of the activity that I would like to chart
date returned is in the following format

Activity timing
a 0:0:33 (hh:m:ss)
b 0:0:54
c 0:1:23
d 0:0:2

but when I give the query to the chart, it only puts the activities on the x axis.
I figure I need to tell the chart that the timing part of the data set is a timespan, I just don't know how to

0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Try this:

base search involving dbquery | rex field=timing "(?<h>\d+):(?<m>\d+):(?<s>\d+)" | eval duration = s + 60 * (m + 60 * h) | chart avg(duration) by Activity

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Try this:

base search involving dbquery | rex field=timing "(?<h>\d+):(?<m>\d+):(?<s>\d+)" | eval duration = s + 60 * (m + 60 * h) | chart avg(duration) by Activity
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...