topic Merging Associated Events in Getting Data In

Merging Associated Events

paddy3883 — Wed, 24 Oct 2012 09:21:31 GMT

I have a script which sends individual events into Splunk, each event is essentially a report on a HTTP Request, either GET or POST. The event contains a number of fields but two key ones are StepName and Timing:

StepName will be a title for the HTTPRequest etc. PostLogin
Timing will be a int value of the milliseconds taken by HttpRequest

I'm writing a report which shows the average time taken for each step over last 15 minutes. However, from an end users point of view, some steps are part of one process e.g.

Step1 - GetLoginPage
Step2 - PostLoginPage
Step3 - ProcessUserDetails
Step4 - GetHomePage

In this case Step2 and Step3 would be one process for an end user, therefore I'd like to be able to report on these as if they were one step so the following:

GetLoginPage 50

PostLoginPage 100

ProcessUserDetails 250

GetHomePage 80

would become

GetLoginPage 50

PostLoginPage 350

GetHomePage 80

I can use a replace on the StepName so I have

GetLoginPage 50

PostLoginPage 100

PostLoginPage 250

GetHomePage 80

How can I then merge these results so it summates the two PostLoginPage steps and then gives me an average over the time period for the three individual steps?

Note each step has a field called TransactionGUID which associates a group of steps for the same execution.

Re: Merging Associated Events

watsm10 — Wed, 24 Oct 2012 10:32:24 GMT

I would suggest searching the documentation for eval(case). I had a similar issue and this was a suitable workaround. If you need any more help, let me know 🙂

Re: Merging Associated Events

watsm10 — Wed, 24 Oct 2012 10:38:18 GMT

so.. eval StepName = case(HTTPRequest="GetLoginPage","GetLoginPage",(HTTPRequest="PostLoginPage" and HTTPRequest="ProcessUserDetails"),"PostLoginPage",HTTPRequest="GetHomePage","GetHomePage")

so it's case(name of fields you wish to rename/combine,"new name",name of fields you wish to rename/combine,"new name".......)

Re: Merging Associated Events

kristian_kolb — Wed, 24 Oct 2012 11:59:19 GMT

Hello,

your_search | replace "ProcessUserDetails" with "PostLoginPage" in StepName | chart sum(exec_time) over TransactionGUID by StepName | stats avg(GetLoginPage) avg(PostLoginPage) avg(GetHomePage)

is one way to do it. exec_time would be the field where the execution time is stored.

Hope this helps,

Kristian

Re: Merging Associated Events

paddy3883 — Wed, 24 Oct 2012 12:13:28 GMT

Thanks, I have found a way to do it not too disimilar to this so thanks for feedback.

Re: Merging Associated Events

paddy3883 — Wed, 24 Oct 2012 12:13:53 GMT

Thanks, I was able to use the eval for this purpose and work into a solution