topic Re: Create a graph with time fields different than event's timestamp in Splunk Search

Create a graph with time fields different than event's timestamp

edrivera3 — Mon, 28 Sep 2020 19:48:37 GMT

Hi
In my events I have the following fields:
1. Initial_time (This is different than event's timestamp) (format=string)
2. End_time (This is different than event's timestamp) (format=string)
3. Process Name (format=string)

I am interested to create a graph which has time in x-axis and process names in y-axis. I want to show the multiple processes and duration time of each of them in the graph. I am not sure if this possible.

I already strptime() both time fields so now I can manipulate them.

If this is not possible. Is there a way to get something similar with a different graph. I want to see the duration of each of the process simultaneously and see if they overlap during some period of time.

Re: Create a graph with time fields different than event's timestamp

edrivera3 — Mon, 28 Sep 2020 19:48:45 GMT

This is what I have already:
(Both time fields are multivalue fields so I am only interested in the minimum value of ini_time and maximum value of end_time.)

...| eval ini_stamp=strptime(ini_time,"%b %d %H:%M:%S %Y") | eval end_stamp=strptime(end_time,"%b %d %H:%M:%S %Y") | stats max(end_stamp) AS high min(ini_stamp) AS low by process_name| eval duration = high - low

So basically I also have the duration time of process_name

Re: Create a graph with time fields different than event's timestamp

stephane_cyrill — Fri, 01 May 2015 16:29:31 GMT

try this:
..........|stats .......................over yourField

Re: Create a graph with time fields different than event's timestamp

edrivera3 — Fri, 01 May 2015 17:12:10 GMT

I do not understand your answer. Could you explain how your answer could help me?