Splunk Search

Make a graph

hxa27
Path Finder

Hi, I am using this query

sourcetype=TraceDropOff| transaction startswith="Starting Main" endswith="DropOff application execution complete" |eval "Event End Time"=strftime(_time+duration, "%m-%d-%Y %H:%M:%S")|eval "Event Start Time"=strftime(_time, "%m-%d-%Y %H:%M:%S")| rename source as "Log Location" | eval Duration(Seconds)=strftime(duration,"%M:%S") | table "Log Location","Event Start Time","Event End Time", Duration(Seconds)

and I am trying to graph the Duration(second) column with the Log Location but since these are not fields am not able to graph my data. Any suggestion??

Thanks

Tags (2)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

How 'bout this?

sourcetype=TraceDropOff | transaction startswith="Starting Main" endswith="DropOff application execution complete" | timechart avg(duration) by source

martin_mueller
SplunkTrust
SplunkTrust

Add this after the timechart:

... | eval duration = duration / 60 | rename duration as "Duration in minutes"
0 Karma

hxa27
Path Finder

ok, and how can I do the minutes ?

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Showing the time in MM:SS on the Y axis isn't going to be easy, if at all possible with the built-in charting. Just go with either seconds or minutes, the viewer is going to understand it.

0 Karma

hxa27
Path Finder

Yes, and showing the time it takes as Y axis in minute ans second

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Sooo... You're looking for max(duration) instead of avg(duration)?

0 Karma

hxa27
Path Finder

we are trying to see how long it takes to receive the response. Then we can set up an alert whenever the process exceeds our max.The graph will be easier for us to read and compare .

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

What should the graph look like instead?

0 Karma

hxa27
Path Finder

Thanks for the response

Probably you misunderstood my question.I am trying to graph the result of each duration but the query you wrote is giving the avg duration.

Thanks again

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!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...