Splunk Search

How to calculate response time for this particular event ?

karthi2809
Builder

How to calculate response time for this particular event ?

I used to transaction command to club the data for same transid .How to find response time for this event

index=test_prod | transaction transid

[2017-10-13 05:28:03,451][LOG ][WARN ] transid=150788451; Path=Q; OperationName=DL; RequestPayload=U-165566193; CaptureLocation=Request
[2017-10-13 05:28:03,479][LOG ][WARN ] transid=150788451; Path=Q; OperationName=DL; TransactionStatus=SUCCESS; CaptureLocation=Response

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi karthi2809,
when you use the transaction command, you always have an additional field called "duration" that calculates the difference betweeen the latest and the earliest event in each transaction.
Is this the "response time" you want?
Bye.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...