Splunk Search

time chart / stats for each type of request and time in log file.

vamsi199
Engager

Hi All,

I have a weird log file which I have parsed using regex to extract fields.(attached screenshot).

Now I want to get

1) time chart/stats for each type request with an average of duration.

2) line chart over time for each request id for all corresponding requests of request id][1].

Thanks,

Tags (2)
0 Karma

somesoni2
SplunkTrust
SplunkTrust

Try like this

1) time chart/stats for each type request with an average of duration.

your current search till rex command..do not include your table command...
| convert dur2sec(duration) | eval duration=if(isnull(duration),strptime(duration,"%H:%M:%S:%N")-relative_time(now(),"@d")
| timechart avg(duration) by name limit=0

2) line chart over time for each request id for all corresponding requests of request id

your current search till rex command..do not include your table command...
| convert dur2sec(duration) | eval duration=if(isnull(duration),strptime(duration,"%H:%M:%S:%N")-relative_time(now(),"@d")
| timechart avg(duration) by operationid limit=0
0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...