Splunk Search

Which timestamp is used when piping a transaction result into timechart command

jbrenner
Path Finder

I have a transaction command which correlates two log entries. If I pipe this result into a timechart command, which log entry's timestamp does it use to bucketize the results (the first or the second)?

Also, is there a way to specify this?

Thanks! Jonathan

Labels (2)
0 Karma

diogofgm
SplunkTrust
SplunkTrust

Hi Jonathan
The time stamp used is the one from the earliest event in the transaction. and I don't believe there is a way to change that. 
Other option, depending on your use case, would be to use stats instead and then you could use min(_time) and max(_time) so you end up with 2 time fields that you can choose from.

------------
Hope I was able to help you. If so, some karma would be appreciated.

johnhuang
Motivator

The transaction will generate a duration field which you can add to _time to get the end time.

 

| transaction ........
| eval _time=_time+duration
| timechart ........

 

Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...