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
Revered Legend

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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...